querying a bill of material table

[Guest]

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!

 

[Guest]

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

 

[Guest]

THANKS!
--
www.Marzetti.com

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