Just curious how are you joining the Warehouse and Customer tables?
P.S.
What I suspected… by joining on Company you’re pulling in all warehouses all customers AND in effect would be multiplying each warehouse be the number of customers.
Yes… these two tables will probably not join “naturally”.
Have you looked thru the Help - there are some good examples there.
I also think it might help if you could look at the menu items in E10 for “Datasets Relationship” and/or “Data Dictionary Viewer” ( especially the indexes ).
Or maybe downloading one of the CHM files from this site might give you some ideas of tables and their relationships? Here is a link to one of the “CHM” topics: