cross table deletions question
Hey All, So I just launched my first app for a non-profit organization. When we went to delete my test data from the main parent table, none of the data on subsequent child tables were deleted. My ...
Forum Discussion
Mary,
Deleting a Parent record does not delete any of the child records. It works symmetrically to the Add Record feature which does not create child records when a Parent record is created. If it did this as a native function you would lose the child records regardless of how many additional Parent records an object might have.
Imagine a Forecast that is directly related to an Office, Region and Corporate Annual Budget. Deleting a record in any of three parents should probably not delete the Forecast which would change the totals in the other tables.
There are plenty of times when you will want to delete child records when a Parent is deleted, but this needs business logic to make sure that you are only getting rid of the right records. Additionally there may be grandchild, great grandchild or deeper records that should be pruned.
I solve this issue using Triggers from Juiced Tech. https://www.juicedtech.com.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Deleting a Parent record does not delete any of the child records. It works symmetrically to the Add Record feature which does not create child records when a Parent record is created. If it did this as a native function you would lose the child records regardless of how many additional Parent records an object might have.
Imagine a Forecast that is directly related to an Office, Region and Corporate Annual Budget. Deleting a record in any of three parents should probably not delete the Forecast which would change the totals in the other tables.
There are plenty of times when you will want to delete child records when a Parent is deleted, but this needs business logic to make sure that you are only getting rid of the right records. Additionally there may be grandchild, great grandchild or deeper records that should be pruned.
I solve this issue using Triggers from Juiced Tech. https://www.juicedtech.com.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
- MarkShnier__You
Qrew Legend
.... in addition to what Don said above, cascading delete of children and grandchildren can also now be done natively with Automations.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank y'all so much!! I'll give this a try.
------------------------------
Brandy Nunes
------------------------------ - Thank you both on this issue. I know have some places to explore to work on this issue in my app. Cheers! Mary
------------------------------
Mary Perkins
M3TR1CS Business Solutions
mary.perkins@m3tr1cs.com
------------------------------
