Forum Discussion
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. Problem is that if some of the open sales orders don't have shipment number yet, those orders will be filtered out if I connect these 2 tables.
I should have all sales orders visible and if they don't have a shipment number, then this field should be empty.
For example order 46225 doesn't have a shipment number but as seen in the last pic, it will be filtered out and only orders with shipment number is visible. I should have 46225 also here but with empty shipment field.
BR
Matt
10 Replies
Matt78Thank you for the swift reply.
It partly works but it will empty article numbers also. I think the issue comes because article numbers come from sales header and shipments are connected to sales lines.
BR
Matt
- JoeBarry
Solution Sage
What 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
- Matt78
Sales 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
