Good Afternoon All,
I’m going to Try to explain this as Clearly as possible as to not cause confusion,
I have 3 Tables.
Table A ~ Parent
Table B ~ Child of Table A.
Table C ~ Standalone.
The User Fills in Form A and Create a Few Childs (Table B).
What I’m looking to do is upon Form Save, Enter a New Row with Data for Each Child into Table C. Data would be based off of Table A and the corresponding Child the Row is being Added for.
User Fills in form (Parent Table A)
User Create 3 Childs within Form (Child Table B)
User Saves Form.
Upon Save I would Than Like to Add 3 Rows to Table C based on Data from Table A and the Corresponding Child.
The User could would also be able to add only 1 child, as well as 4 Childs. This is the unknown variable Im having trouble with. But this needs to Stay Variable.
Preferably not with a Counter in the spreadsheet for looping, I seen a post somewhere about forms advancing Automatically bla bla bla but cant find this anymore anywhere.
Solved! Go to Solution.
Action 1
TRUE
(or blank)Action 2
[Related Table Bs]
ISNOTBLANK([Related Table Bs])
Set the Form Saved event action to action 2.
Can the user add children after the initial save of the parent? If so, how would you see that being handled?
No they Cannot
Action 1
TRUE
(or blank)Action 2
[Related Table Bs]
ISNOTBLANK([Related Table Bs])
Set the Form Saved event action to action 2.
Let me Try this, I have something else that just came up so I will get back to you but not right away
Steve, Thanks You, this worked perfectly on the first iteration.
User | Count |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |