Subform mystery

[Joe]

Hello.

I have an app where I have a table for Agency data
(AgencyID = pk), a table for Member data (pk = MemberID)
and a table to link them in a many-to-many relationship
(which contains AgencyID and MemberID as its only fields).

I need to display in a subform all of the Memebrs that
work with a given agency. To do this I want to use the
AgencyID of the chosen Agency to locate in the link table
which Members work with that agency. I then want to
display in a subform (?) the member data in Datasheet view.

Does anyone know how to do this?

I tried a previous post's suggestion and I couldn't get it
to display all of the Member data that I need.

TIA,

Joe

 

[Jack Peacock]

Hello.

I have an app where I have a table for Agency data
(AgencyID = pk), a table for Member data (pk = MemberID)
and a table to link them in a many-to-many relationship
(which contains AgencyID and MemberID as its only fields).

Does anyone know how to do this?

For the subform, can you create a JOIN between the intersection set and
Members? Then for each intersection membership record you'll also have the
full Member record keyed by the common MemberID key.

Oops, just saw I used old Codasyl terminology. What are intersection sets
(the intermediate table for a many to many) called in Access?
Jack Peacock