I have 3 tables: Purchasing, Sales and Work Orders
Purchasing is lot number and quantity
Sales is lot number and quantity
Work orders is Parent lot and Component lot and Quantity.
I to show work orders only where the parent lot equals the sales lot number and component lot equals the purchasing lot number.
**Don't know if it's relevant, but I need the Purchasing and Sales lot numbers to align, thus
Not sure if I'm not explaining it correct, but the report has to do with imports and exports, I have a list of all the imports (Purchasing) and then I have a seperate list with the exports (sales). The last piece is to look at workorders . During that process a component lot is changed and becomes a different, parent lot. I have a list of all the workorders along with their component lot numbers and parent lot numbers. I was hoping there was a way to look at a workorder and if the component exists in the purchasing table and the parent in the sales table then include it in the workorder table. Is this possible? I have the first part done the workorder table is whats really messing with me.
I'm not sure if this is what i'm looking for. I need all from the purchase table, all from the sales table and the subset of the workorder table that occurs in both sales and purchase. Is that clearer?