Ask Your Question

Form change data with substitution from referenced table [closed]

asked 2013-03-15 16:20:51 +0200

135 gravatar image


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:

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 16:23:21.672236

1 Answer

Sort by » oldest newest most voted

answered 2014-09-30 12:31:37 +0200

Goyo gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-03-15 16:20:51 +0200

Seen: 109 times

Last updated: Sep 30 '14