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
Thanks Mr. Shnier, Just now I understand your comment, this is not the appropriate forum for that question.
Thank you!
Marcelo Beanvides Torres
Hi Marcelo,
I think it's an interesting question, though actually in my usage I'm kind of glad that it doesn't work that way. In my database we have a trio of tables: grandparent A, parent B, and child C, which are:
A=Companies
B=Contacts
C=Notes.
We record Notes record that show on both the Contact and the Company record. When a Contact leaves a company, they get deleted because well, too many contacts clutter the search, etc.
However we want to preserve the Notes from our interactions with that person on the Company record because they may be relevant to ongoing business activities. So for us it is a good thing that we can delete that parent record (Contact) without deleting the child (Notes) which still appear on the grandparent (Company) record.
I do understand however that in other situations it can be annoying because you would end up with orphan children. (That does also happen in our system in other areas which I need to do a better job of keeping track of, though it's less common.)
------------------------------
Kim G
------------------------------
I think it's an interesting question, though actually in my usage I'm kind of glad that it doesn't work that way. In my database we have a trio of tables: grandparent A, parent B, and child C, which are:
A=Companies
B=Contacts
C=Notes.
We record Notes record that show on both the Contact and the Company record. When a Contact leaves a company, they get deleted because well, too many contacts clutter the search, etc.
However we want to preserve the Notes from our interactions with that person on the Company record because they may be relevant to ongoing business activities. So for us it is a good thing that we can delete that parent record (Contact) without deleting the child (Notes) which still appear on the grandparent (Company) record.
I do understand however that in other situations it can be annoying because you would end up with orphan children. (That does also happen in our system in other areas which I need to do a better job of keeping track of, though it's less common.)
------------------------------
Kim G
------------------------------
- HI Kim...It is an interesting example.From the ACADEMIC: the record you are deleting "should" be left in an inactive status, so you never lose a parent's history.I repeat that it is something strictly academic and how the college teach us to take care of information.But the ambiguity of computer science remains: "if it works for you .... that's fine"Thank youMarcelo Benavides