Combo boxes drop down list selection ...

  • Thread starter Thread starter Jamie Risk
  • Start date Start date
J

Jamie Risk

If I have a combo box use rowsource looks like:
SELECT People.People_ID, People.Surname &", " & People.Name & " State:" &
People.State_ID FROM People ORDER BY People.Surname

and I've got a table
State ( State_ID Autonumber, State Text)

How can I change my rowsource above to replace the "People.State_ID" field
with the text State.State (using State_ID as the key)?

- Jamie
 
Join the two tables:

SELECT People.People_ID, People.Surname &", " & People.Name & " State:" &
State.State FROM People LEFT JOIN State ON People.State_ID = State.StateID
ORDER BY People.Surname;
 
Back
Top