Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, 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: 2825
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 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