That looks like it, thanks a lot

RB

I tried your suggestion but I still get the same error message about not being able to enlist in the specified transaction coordinator.

RB

Apologies if this message is posted twice but the first time I posted it nothing seemed to happen.

Thanks for the above comments. It will take me a little while to...

Thanks

I've come up with this which seems to work ok.

CREATE TRIGGER [UpdateDA] ON [dbo].[ImagingEmu]

FOR INSERT

AS

DECLARE @IRN char(12)

SET @IRN = (SELECT IRN FROM inserted)

IF(SELECT COUNT(IRN) FROM ProductionControl WHERE IRN...

Thanks for the reply,

Unfortunately there is no primary key in 'inserted'. This is for a request system. A primary key only gets generated when the request is inserted into the ProductionControle...

Thanks, I'll give it a go.