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
I would say this is a good question and a problem most Quickbase Admins/builders eventually face. There are no "before you start building there are a few things you should know" articles I am aware of that warn us to remove delete rights. This is one of those problems everyone will face and then come to their own conclusions on how to make it work. This design is an open architecture and preferred.
It is nice to have the open design. It is not so nice to come in to work and find out that yesterday you deleted all the parents and now no one can see the children and now you have to put it all back etc. etc. this is not fun but a great way to never forget.
One last note, Quickbase does have a restore feature, so one can put it back to the previous nights backup. That is the extent of the granularity to restore. There are no transaction logs one can replay.
While you're paying attention, another thing to be aware of, once a record is deleted, you cannot ever get that record id back other than by a table restore. So if your record id is number 123 and you deleted it from the table, you will see record id 122 and then 124. This subtle distinction becomes very important when working with related fields.
Good luck Marcelo, good observation!
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
It is nice to have the open design. It is not so nice to come in to work and find out that yesterday you deleted all the parents and now no one can see the children and now you have to put it all back etc. etc. this is not fun but a great way to never forget.
One last note, Quickbase does have a restore feature, so one can put it back to the previous nights backup. That is the extent of the granularity to restore. There are no transaction logs one can replay.
While you're paying attention, another thing to be aware of, once a record is deleted, you cannot ever get that record id back other than by a table restore. So if your record id is number 123 and you deleted it from the table, you will see record id 122 and then 124. This subtle distinction becomes very important when working with related fields.
Good luck Marcelo, good observation!
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
Very good contribution. Thank you Jim
Marcelo Benavides Torres