combobox and two different table as source

[DevAccess]

Hello

I would like to have a combobox which would take values from two different tables, more precisely it would query and one table.

the problem is that if I create like that it does not update rest of fields on rest of the form.

what would be best way to have rowsource of combobox from two different tables i need this info because my primary table does not store first name and last name, it stores only ID so I am making relationship between them but it works as well but it does not updates the rest of the form data.

thanks

 

[Ranman256]

Why do you need data to choose from 2 tables?
If cities, you pick from a city table.
If people,you pick from a person table.
Why 2?

 

[DevAccess]

Why do you need data to choose from 2 tables?
If cities, you pick from a city table.
If people,you pick from a person table.
Why 2?

I have two tables one table contains ID and one table contains name so I want to have relationship between these two tables which would give me names accoudning to ID from first table.