Delete parent record... ???
Good morning. In a relationship there is table A(parents) and table B (childs) . Since my beginnings in quickbase I have question... ¿Why does quickbase allow you to delete records from table A...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt's not really a valid question to ask. It is just not an automatic capability that is part of the product features at this time.
You can either use the feedback process to suggest an enhancement or post a question as to how you can adapt to this situation if you are looking to prevent allowing regular users deleting a Parent record when it has children.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
You can either use the feedback process to suggest an enhancement or post a question as to how you can adapt to this situation if you are looking to prevent allowing regular users deleting a Parent record when it has children.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Good morning Mr. Shnier.I think this is a valid question, in my 24 years of experience (software developer) it is the first software I know of that allows you to delete parent records from an entity relationship schema.About looking for mechanisms to avoid this: I already did it, remove the options to delete all users and with URL - buttons and formulas I can control this situation (show or not a delete button for each record).Having the capabilities to do what I've just mentioned I don't think will diminish or validate my question.Thank youMarcelo Benavides Torres
- MarkShnier__YouSorry, I was not trying to say that this would not be a useful feature. I'm just saying that given that this forum is mainly used for a peer to peer help each other type forum, the knowledge of why or why not a feature was build 20 years ago when Quickbase was invented is hard for us to answer.
In my case I block delete for all regular non admin users. Then a provide a checkbox to request deletion and have a Pipeline do the delete if there are no children.
The other reason not to automatically block deleting a parent if there are children, is that there are use cases where the desired outcome is to delete the parent and its children automatically so as not to leave Orphans. This can also be done with a Pipeline
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Thanks Mr. Shnier, Just now I understand your comment, this is not the appropriate forum for that question.Thank you!Marcelo Beanvides Torres
