I have two tables invt.dat and strstk.dat
invt.dat stores information on inventory stock and strstk.dat stores information on which stores hold what stock quantities.
I want to create a report that lists stock and the holdings in each store.
invt.dat has one line in each table for each product line. It simply looks like this
With data looking like this
strstk.dat looks like this
The data in strstk looks like this though
So when I link the two tables by SKU the report I print gives me three lines per product when I really want this...
Can someone help me create a formula or solution that can yield this report?