Combo boxes drop down list selection ...

[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

 

[Ken Snell [MVP]]

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;

 

[Jamie Risk]

We've collided in this group before; again, thanks.
- Jamie