Form change data with substitution from referenced table

[135]

Hi.

For example I have two tables (“person” and “city”) which referenced by “city_id” field.
I created form with subform (MainForm - person, SubForm - city). Data show correct, I see right “city_name” for each person.

But I can’t change city for person. Combo box field changed data in the city table.

Please help. How I could change city in the person table by combo box with display city_name from city table.

example file: http://4x4krasnodar.ru/person-city.odb

[Goyo1]

I guess you want to use only one form (using “person” as data source) and then a list box for city_id in that form.