Adriaan, this one seems to work better. thanks again for your assistance. CREATE Trigger MAIN_Lost_Stolen On dbo.MAIN FOR UPDATE AS declare @viso...
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.
