cross table deletions question

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 understanding is that all associated data in other tables should have been deleted as well. What did I set up incorrectly or miss in the set up process?Cheers,------------------------------Mary Perkins M3TR1CS Business Solutionsmary.perkins@m3tr1cs.com------------------------------

donlarson · Answer

Mary,Deleting a Parent record does not delete any of the child records.&nbsp; &nbsp;It works symmetrically to the Add Record feature which does not create child records when a Parent record is created.&nbsp; &nbsp;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.&nbsp; 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.&nbsp; Additionally there may be grandchild, great grandchild or deeper records that should be pruned.I solve this issue using Triggers from Juiced Tech.&nbsp; &nbsp;&nbsp;https://www.juicedtech.com.------------------------------Don LarsonPaasporterWestlake OH------------------------------

markshnier__you · Answer

.... 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
------------------------------

brandynunes1 · Answer

Thank y'all so much!! I'll give this a try.------------------------------Brandy Nunes------------------------------

maryperkins · Answer

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 Solutionsmary.perkins@m3tr1cs.com------------------------------

Forum Discussion

cross table deletions question

4 Replies

Related Content

Chart Question

Deleting Orphaned Children (records)

delete a question

Questions & Checklist setup

cross table deletions question

Recent Discussions

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns

Quickbase JMP connection