> I 'delete' a record while there are still references to it, and the RDBMS cannot even warn me, much less stop me! Can't you do multi column FKs ( (otherid, a

> I 'delete' a record while there are still references to it, and the RDBMS cannot even warn me, much less stop me! Can't you do multi column FKs ( (otherid, active) references other(id, active) )?