View Single Post
Old 06-10-2010, 10:19 AM   #2
Win10 Office Pro 2016
Join Date: Jul 2008
Location: Tokoroa, New Zealand
Posts: 2,269
Thanks: 74
Thanked 78 Times in 74 Posts
PNGBill will become famous soon enough
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.
PNGBill is offline   Reply With Quote