create record + add child records in one step
Hello, Is there an easy way to set up a form so that when I click Save, it first creates the parent record, then creates the child records which are filled in a grid edit format and associates them...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAre you asking if you can create a child record and have a parent record be automatically created for it? I'm not really understanding your proposed workflow.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
No, you are creating both parent and children in one step. You know how you can display a report with specific columns on the form and enable it to be editable in add and edit mode? I have that for the child records on my form in both add and edit. So the user fills out some detail about the parent record, then starts to fill in the child records. For example the parent is a Group and the child contains Group Members. The user wants to add group details and add members all in one step.
If you go into edit mode in a Group and add multiple child records via the grid, QB is smart enough to automatically relate them to the parent. But if you do it when adding a new record, there's no Record ID# generated for the parent record yet, so the save fails. (Related Group is a required field for each Group Member).
------------------------------
Rachel Rachel
------------------------------
If you go into edit mode in a Group and add multiple child records via the grid, QB is smart enough to automatically relate them to the parent. But if you do it when adding a new record, there's no Record ID# generated for the parent record yet, so the save fails. (Related Group is a required field for each Group Member).
------------------------------
Rachel Rachel
------------------------------
- MarkShnier__YouOk, now I understand. Can you try making the related parent field not required. I should still fill in on its own when you save.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Such a simple solution!
I required Related Group in the Group Members form instead of at the field level. That way people can't make orphaned Group Members by creating them one by one.
Thanks!
------------------------------
Rachel Rachel
------------------------------