Is there a way to not allow a row in Table A to be deleted if Table B has already mentioned its value (a column in Table B refs Table A)?
Example: I have a table called Runs which lists ferry run information, one row per run. I then have a log table which records ferry boardings, and which has a column the value of which is a run in the Runs table. The way the app works now a user is allowed to delete a row from the Runs table (don’t ask). But I don’t want to allow that if the log table already contains a mention of that run.
As it is now the Delete property is defined for all rows in an entire table, on or off. Is it possible to actually assign conditions to that delete?
Maybe a condition on Editable_If on that column?