Re: Creating a report from Multiplace Tables
The way you describe your tables they are not setup properly.
Look for normalizing in your help.
You can't repeat the same name on your tables if they are the primary Key fields.
InventoryTable should be your main table and the Primary Key would be ProductID or SKUNumber - an auotnumber.
Any other tables will have their own Primary Key and may then include ProductID as a normal field.
The description of multiple results suggests your relationships are not right and or your select query is not right.
Check out the table structure, setup your table relationships and then work on your queries and from there your reports.
I would suggest you may not need a table PackageSign as this may be a calculated issue.