How to avoid deleting a database record:

[piscis]

With the diagram shown below it is clear that I cannot delete any records for the tables connected to the center one because of foreign key constrains.

I could however delete any records found in the main table “Listing”.

What functions or properties can I give to this table “Listing” so NO records can ever be deleted?

Thanks

[szlamany]

Is this MS SQL SERVER??

Look into INSTEAD of TRIGGERS - and simply stop the DELETE with that.

I don't have SQL here to play with or I would whip one up for you...