querying a bill of material table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnLute - 10 May 2005 17:34 GMT

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!

Signature

www.Marzetti.com

Reply to this Message

jl5000 - 11 May 2005 03:06 GMT

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

Signature

jl5000
<a href="http://www.joshdev.com"></a>

> I have two tables with these pertinent fields:
> tblProfiles
[quoted text clipped - 21 lines]
> Thanks!
>

Reply to this Message

JohnLute - 13 May 2005 16:52 GMT

THANKS!

Signature

www.Marzetti.com

> Are you working with one level BOM? if so:
>
[quoted text clipped - 31 lines]
> > Thanks!
> >

Reply to this Message