Subform issue

[larochy]

Hi,

Not sure if this is a table problem or a subform problem. I have two tables:

tblInterview
InterviewID
Date
Volunteer1
Volunteer2

tblVolunteers
VolunteerID
Full Name
Phone Number

I'm trying to show a form based on the Volunteers table that shows the
Volunteer information at the top and any related Interviews they've been
involved with. They can be in either the Volunteer1 or Volunteer2 field.

When I try to join the subform on eith the Volunteer1 or Volunteer2 field
matching up to the Volunteer ID, it doesn't work. I'm assuming it wants to
see the Volunteer ID show up in both fields.

What am I doing wrong here? Table design or form issue?

Thanks

 

[larochy]

Thanks

The Volunteer1 and Volunteer2 fields are linked to the Volunteer ID in the
Volunteer table. If I get rid of the Volunteer1 and Volunteer2 fields and
replace it with the VolunteerID, how do I show that there were two volunteers
for the one interview?