combo box

[nancy]

I have two lists of people I would like to have listed one combo box.

One is from Volunteers Table
And the other is from a familymember table.

The Familymember table has a relationship with the Volunteer talbe.




Select volID, volName & " " & VolLastName From Volunteers and volID,
FamilyID, Person1 Name, Person2 Name, Person 3 Name, Person 4 Name,
Person5 Name from FamilyMembers [VolName] where Inactive = 0 order by asc


Is it possbile to do this?

 

[Jeff Boyce]

Provided your queries have equal numbers of fields, and comparable contents
in those fields (i.e., no 'apples' and 'oranges'), you could look into using
a UNION query (see Access HELP) to join the results from each of those.

Regards

Jeff Boyce
Microsoft Office/Access MVP