Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Subform foreign key column not populating from masterrecord

Post Reply
clinterman
Posts: 24
Joined: Thu Apr 05, 2012 7:53 am

Subform foreign key column not populating from masterrecord

Unread post by clinterman »

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?
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Subform foreign key column not populating from masterrec

Unread post by admin »

clintername,

Remove the hidden ids nuBuilder will populate them automatically.

Steven
Post Reply