Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Form change data with substitution from referenced table


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: