Search for Jobs by Sub-Assembly

Thank you Roel. At least it's nice to know I wasn't missing it.


 Sincerely,


Stephen Schaefer
Abrams AirborneÂ

[Non-text portions of this message have been removed]
Hi all,
Maybe I am missing it, but is there a way I can find all the Job that have a particular Sub-Assembly?
I can't seem to find where I can search by Sub-Assembly.
 Sincerely,


Stephen Schaefer
Abrams Airborne

[Non-text portions of this message have been removed]
Good morning Stephen.

I would create a BAQ, just using the JOBASMBL table and selecting only Assemblies/records where BOMLEVEL is greater than 0. Then I would convert the BAQ into a simple Dashboard with a Prompt for JobAsmbl.PartNum. Let me know if you would like more detail on this idea.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705



[Non-text portions of this message have been removed]