Subform foreign key column not populating from masterrecord
Posted: Sun Jan 06, 2013 7:55 am
I have a form with
pickuppointgroup containing ID, Name
subform
pickuppointgroup_pickuppoint containing ID, pickuppointgroup_id, pickuppoint_id
form
pickuppoints containing ID, name, city
On the subform I registered Primary key ID, Foreign key pickuppointgroup_id. The subform has 2 hidden fields d_id (select '#id#') and pickuppointgroup_id. When inserting a new record in the subform the pickuppointgroup_id stays blank. How can I get this populated, with the pickuppointgroup_id of the masterrecord?
pickuppointgroup containing ID, Name
subform
pickuppointgroup_pickuppoint containing ID, pickuppointgroup_id, pickuppoint_id
form
pickuppoints containing ID, name, city
On the subform I registered Primary key ID, Foreign key pickuppointgroup_id. The subform has 2 hidden fields d_id (select '#id#') and pickuppointgroup_id. When inserting a new record in the subform the pickuppointgroup_id stays blank. How can I get this populated, with the pickuppointgroup_id of the masterrecord?