Thanks Mark - that will work!
I use the same technique Mark describes and put a bit of effort into styling a conditionally visible Form Rule message (with Bootstrap Alerts) to guide User to create the Child via the Parent. That should prevent duplicating records, but I'd require the Related Parent at the Field level (checkbox) vs. the Form level if that makes sense.
Styling and clearly presenting a helper message helps saves time and reduces confusion especially. The native Quickbase message when attempting to save can be unclear:
"You do not have modify access to the required field "Your Field Name"
Please contact the administrator of this application to report this issue.
It doesn't sound like you want the native copy functionality at all, but please note there is an additional field setting to "Copy the value" that may be (un)checked. Alternatively, you could create a Copy formula URL button that takes the user to the add record form with values pre-filled from an existing child, from the context of where that button would be pressed.
------------------------------
Brian Seymour
------------------------------
