Forum Discussion

CharlotteM's avatar
CharlotteM
Qrew Assistant Captain
8 years ago

conditional dropdown with add a record - populate child field from parent

I have two tables - company and contact.  One company (parent) has many contacts (child). I create a company.  Then click Add a contact.  The contact  form opens in another window - but the company...
App builders
Ask about Quickbase functionality
Forms
CharlotteM's avatar
CharlotteM
Qrew Assistant Captain
8 years ago
yes, I'm using the button.

It has this:

URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=API_GenAddRecordForm&_fid_39=" & URLEncode ([Record ID#])& "&z=" & Rurl()

It seems that when I save the parent first, then click on Add Contact, it works properly.  I have
"Save parent record automatically when a child record is created" checked on both tables (because sometimes I'm wanting to create a Company from another table/ parent record).  So it's acting like it doesn't actually save the Company (parent record) before trying to add the child.

And it doesn't actually connect the two - the contact is saved, with no company.
CharlotteM's avatar
CharlotteM
Qrew Assistant Captain
8 years ago
Exactly.... but that is what it does not seem to be doing. I am in add mode on the parent, then click to add the child.  The form to add a new child opens, with no link to the parent.  What am I doing wrong?