Forum Discussion
Matt78
Helper II
Helper IIData from another table filters out empty fields (should be visible)
Hello, I have 2 data sources, other one is sales order list and other one is warehouse shipments with shipment numbers. What I would like to have is to get shipment numbers to my sales order list...
Matt78Helper II
Helper IISales orders has a unique numbers, yes. These have relationship to Sales Lines so I can get articles each order contains. Sales Lines have relationship to Shipments, where I can get shipment numbers.
Sorry, I wasn't clear enough in my original post. I said 2 tables but there is 3 actually.
Sales Order Header:
order 46225
Sales Lines
order 46225
article 1
article 2
article 3
Shipments
order 46225 shipment SH123345
article 1
article 2
article 3
JoeBarry
Solution Sage
Solution SageThen the Sales Order Header should have a one to many relationship to both Sales Lines and Shipments on the Order ID column