tie multiple values from second table to first table

[Amanda]

not sure if the subject explains the process but....

I have a Membership Table that holds a people ID field that relates to the
People Table where I hold information like First Name and Last Name. Because
our Family Memberships can have two names on them, my Membership table has a
People ID 2 field that also corresponds to the People table.

I want a query that pulls the first names and last names for
membership.[people ID] and the first name and last name for
membership.[people id2]

How do you structure such a query?

Thanks, Amanda

 

[John W. Vinson/MVP]

not sure if the subject explains the process but....

I have a Membership Table that holds a people ID field that relates to the
People Table where I hold information like First Name and Last Name. Because
our Family Memberships can have two names on them, my Membership table has a
People ID 2 field that also corresponds to the People table.

I want a query that pulls the first names and last names for
membership.[people ID] and the first name and last name for
membership.[people id2]

How do you structure such a query?

Thanks, Amanda

You can join the people table to the Membership table *twice* - add
People to the query grid a second time (Access will add _1 to the
table name as an alias so you can distinguish them); join one instance
to People ID and the other to People ID2.

I'd suggest a different table design however; if one Membership can
consist of multiple people, you really should have a separete *record*
for each person, not a different field.