Forum Discussion
Helper IIData from another table filters out empty fields (should be visible)
Solution SageWhat is the relationship between the two tables? I will presum that the Sales orders has a Unique No_? If it does create a one to many relationship from the No_ column in Sales Orders and the Order.OrderNumber column in Warehouse Deliveries. This should solve the issue
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
Then the Sales Order Header should have a one to many relationship to both Sales Lines and Shipments on the Order ID column