Query for table with multiple entries in one record

[Guest]

I have two tables I am using right now. The first table has a bunch of
information including fields that require a numeric indentifier for a parts
list. The second tables is the relevant information for the parts list. I
am attempting to put all of this in a report and have a parts list with
complete information displayed for each unique record (all parts will not be
required for each record). I have tried several queries, but I cannont get
the two tables properly linked because in the second table I have a part #
that is associated with the part # in up to 10 different fields in the first
table. To add to the trouble, I also have a field for how many of each part
I will need, and this will also need to be displayed.

I also realize that I might need to reorganize my tables to make this
process go smoother, but as of yet I have not come up with any ideas.

Any help would be greatly appreciated.

 

[MGFoster]

You're trying to create a Bill of Materials (BOM) db. BOMs have been
discussed many times on comp.databases.ms-access and other DB
newsgroups. Search the Google Groups archives of
comp.databases.ms-access for BOM discussions. Try this URL (watch out
for line wrap):

http://groups-beta.google.com/group...81&as_maxd=24&as_maxm=3&as_maxy=2005&safe=off

 

[Guest]

Thank you very much. I knew this had to be a problem other people have
experienced, but have not been able to find anything about it. Thanks for
giving me a starting point.