Compare and contrast 50 tables

[Harry]

First my apologies for the length of this post. I have 50 tables that that
are Bills Of Materials that I need to combine into 1 Planning Bill. A
Planning Bill will have every Part Number in all 50 tables once and the
percentage of instances. Fo example if a part number occures in 4 tables with
a quantity of 1 then the Planning Bill will show that it is used 8% of the
time.
I have created summation queries for each table and each query has these
fields
Part Number
Description
SumOfQuantity
MinOfUnitMeasure (EA,LB,ect)
Stocking Type
Ext Cost

These 50 tables represent 1 product family and I have several dozen more to
do so any guidance you may offer would be greatly appreciated. Thank you in
advance for your help.

 

[Tom van Stiphout]

On Wed, 16 Apr 2008 06:19:00 -0700, Harry

Impossible to say without knowing the relevant table structures. If
you truly have 50 BOM tables you have bigger problems than how to
create a PB (which should be a query, not a table).

-Tom.

 

[Fred]

You need 2 tables instead of 50. For example one is "parts" with one
entry for eavry item, including assemblies. The other is BOM items with
one record for each instance of a part being used in an assembly......three
fields: assemblyPartNumber, ItemPartNumber, Quantity.

Then everything that you are asking about will become easy.

Hope that helps.