JayEdgar
Posts: 77
|
Posted: 02/23/2012, 7:47 AM |
|
I'm amazed I haven't faced this before.
On a current project I have a number of instances where a form needs a subform (child records) for additional information. I'm not actually using subforms on the same page, but opening a new page in a new tab or jQuery dialog box.
When Child records are added, they need the foreign key (FK) to the parent record's primary key (PK) added to be associated to the parent record (obviously). If I update the Child's FK automatically this causes problems, as the user may not need to add 3 (or even 1) new records!
Currently I'm putting a "Fill" button next to the FK field on the child form. How have you handled the same situation? I'm thinking that before save I can update the FK field with the value, and I'm not sure of the best way to do that.
Thanks in advance,
Jay
|
|
|
cvboucher
Posts: 191
|
Posted: 02/23/2012, 10:37 AM |
|
What I've done in the past is to set the Custom Inert Type to Table. Then for the parameter I want to populate I set the "If parameter is empty: Use value" to Request.QueryString("s_SomeSearchField") of a search parameter (VB.NET). You will need at least one field in the editable grid that gets populated by the user so CodeCharge knows it is inserting that record.
I've also used this to populate current date/times into new records and it will also work for hidden fields if you don't want to give the user the option of selecting the parent record in a drop list.
HTH,
Craig
|
|
|
JayEdgar
Posts: 77
|
Posted: 02/23/2012, 10:59 AM |
|
Craig, that's brilliant! I'm so glad I posted in here--I wasn't very hopeful.
Thanks so much!
Jay
|
|
|
JayEdgar
Posts: 77
|
Posted: 02/27/2012, 2:14 PM |
|
I added something else to Craig's suggestion. The foreign key for this table is passed via query string ($_GET). I added code to the Form_BeforeShow code that if the get string is empty, set $Form->EmptyRows = 0. This way, they can't even add new data if the parameter isn't sent.
Craig, thanks again for this elegant solution!
Jay
|
|
|
|