Forum Discussion

DannyIm's avatar
DannyIm
Qrew Member
7 years ago

Deleted record but related records still have a reference to it

Hi, I have two tables "A" and "B" where "A" has a field that is a numeric reference to "B".  I have an "A" record, "a", that contains a reference to a "B" record, "b", but when I delete "b", "a...
App builders
Ask about Quickbase functionality
Relationships
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
QuickBase does not support "Cascade Delete" behavior so this is the expected behavior. But it would not be difficult to implement this behavior in script with or without using a Service Worker (there are two entirely different solutions one of which would use a SW). Either way automatically deleting records might cause other issues if the records in question had yet other relationships to other tables.
DannyIm's avatar
DannyIm
Qrew Member
7 years ago
I wasn't really thinking of deleting the related records, but more of a "ON DELETE SET NULL" type of behavior.  I see that in the web interface record "a" doesn't appear to have any references to "b" anymore, which doesn't match the response returned by the API. 

Thanks for the prompt response.