How to use GenAddRecordForm and update the child record's multiple fields using data from the parent record

Question

I am trying to add a related record and update the URL code to include updates to the child record with data from one more than one field on the parent record. I have been unable to find any code examples and after several attempts, and not knowing for sure if this is even possible, I find that I need to ask for help! I thought this would be simple (old school SQL guy) but I keep failing. Really appreciate a hand!

Original Code:
URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([WAN-Xchange Loc ID])& "&z=" & Rurl()

From the parent record, I want to include:

[Client (Related)] into to child record field ID 9
[Project (Related)] into to child record field ID 11
[Bid (Related)] into the child record field ID 15

URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([WAN-Xchange Loc ID])&_fid_11 =& URLEncode [Client (Related)]& "&z=" & Rurl()

------------------------------
David Lessin
------------------------------

MarkShnierYou · Answer

I can help you with this but before I give you what you asked for let's make sure it's actually what you need. Typically when you have a child record and you want to populate fields on the trail record from the parent, you simply edit the relationship and add look up fields.

Are you familiar with look up fields on relationships, maybe that's all you need.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community