I created a query combining Beg Inv table, Purchases table, Sales table, Adjustment tables. All tables are linked with referential integrity.
However I'm getting duplicates for purchases, Sales, Adj.. I added columns with auto numbers for each purchases, sales and adj. I just don't know...