I am trying to merge three tables: inventory, Open PO, and Sales. When I choose the SKU as the item to match, the table comes up for me to decide what data to pull in. I bring in from my open PO file the quantity, the delivery date, and the delivery remainder. When I add this information, the quantity in my sales table all turns to the same number, and in my country area column, I loose some of the countries that were there before trying to merge the table. - Thoughts?
That's difficult to diagnose based on one picture alone. Could you perhaps share an example file with the query that doesn't give the desired result? and mention what result is expected, please.
@riny, is there a way to share my file with you so that others don't see my work data?
Sure! Send it to the following address:
kpmnhlmn at duck dot com
