Prevent deletion of associated records
just a quick query, as databridge doesn't create a delete page, as dataassist 2 did.
I have a set of reference tables, to which rows can be appended, updated or deleted.
I want to prevent deletion of (for example) a row where the colourid of a specific colour in the reference table is used in the tblproductcolour table, so I don't get orphan rows.
Beforehand it was relatively easy, i would have a recordset based on tblproductcolour on my delete page filtering by colourid, and if the rowcount was > 0 then deletion would be prevented.
What is the best way to do this ?