Using the Items form, there is a quick link to Current Operations.
One can setup a new Item and the Current Operations associated without creating a Job.
Looking beneath the hood, the Current Operations form has the Primary Collection of SLJobRoutes. The Primary table is jobroute.
Dumping jobroute_mst, the Item is not part of the data. In this dump a Job number is shown. But, as explained, no job has to be created to add Current Operations.
Goal: Show all items that use a specific Work Center.
I can filter in Current Operations form by WC and get what I need. However, I want to produce the same dataset without the form.
The linkage, correct table, etc., eludes me.
Any suggestions?
Regards.
