this one seems to work better. thanks again for your assistance.
CREATE Trigger MAIN_Lost_Stolen
Maximum field length is 16, and the column has zero length default.
I put the check statement as below
IF EXISTS (SELECT * FROM inserted WHERE ISO IS...
When the lostcardcode is being updated to a 'LOST' or 'STOLEN', the trigger ran and updated the ISO, ISOparse,
and the lostcardcode = 'Printed...
Yes, they are unique in both tables.
Adriaan, Thank you for your input.
Yes, only one row get updated at a time. The trigger ran only when column lostcardcode is updated. It updated...
Folks, thank you in advance for any input or suggestion.
I got the trigger below working, but for some reason, during the record update to the main...
Separate names with a comma.