Oh, I understand this. But this error is returned when I'm changing a single record in a grid, the grid in Enterprise Manager precisely. Logically, the INSERTED table should only contain a single record. Academic, though...I see that I need to code this way.

This 'IsPending' field is only changed to false (0) because the changing records in the child table, marking a document 'Pending', runs a trigger updating the IsPending field in the parent table to true (1).

The trigger here will allow me to mark the master as 'not pending' and have that change cascasde down to the child records.

Question: why do you need

WHERE i.IsPending <> d.isPending -- Only if IsPending changed

 

if I use

IF UPDATE(IsPending)

?

-------

at us, very deafly, a most stares

collosal hoax of clocks and calendars

eecummings