querying a bill of material table

J

JohnLute

I have two tables with these pertinent fields:
tblProfiles
txtProfileID (PK)
Description
Type

tblProfilesAssociations
txtProfileID (PK)
ProfilesAssociations (PK)
Comments

tblProfiles is in a one-to-many relationship with tblProfilesAssociations.

tblProfilesAssociations functions as a bill of material which stores
associated txtProfileID's in the ProfilesAssociations field.

What I'd like to do is query tblProfilesAssociations.ProfilesAssociations
along with their respective tblProfiles.Description entries.

Is this possible?

Any help would be greatly appreciated!

Thanks!
 
J

jl5000

Are you working with one level BOM? if so:

-Create a query calling tblProfilesAssociations, and tblProfiles twice, the
second call of tblProfiles will add _1 to the table in the design
-Join table tblProfilesAssociations.ProfilesAssociations to
tblProfiles.txtProfileID
-Join table tblProfilesAssociations.txtProfileID to
tblProfiles_1.txtProfileID
-Select the fields you want to show in your query
 
J

JohnLute

THANKS!
--
www.Marzetti.com


jl5000 said:
Are you working with one level BOM? if so:

-Create a query calling tblProfilesAssociations, and tblProfiles twice, the
second call of tblProfiles will add _1 to the table in the design
-Join table tblProfilesAssociations.ProfilesAssociations to
tblProfiles.txtProfileID
-Join table tblProfilesAssociations.txtProfileID to
tblProfiles_1.txtProfileID
-Select the fields you want to show in your query
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top