I would like to create a trigger to stop the update of an existing record, if the date is less than a date for that event type in another table
if the date of the record being updated is < select Date from OtherTable where eventType = (event type of row trying to be updated)
I would still need to do inserts but not updates.
This is my 1st trigger so excuse me if its a really simple thing, but i have googled and dont find anything quite like i think i need
View Complete Post