combo box

  • Thread starter Thread starter nancy
  • Start date Start date
N

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?
 
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
 
Back
Top