I read the post but I'm sure I misunderstood something -

Here's a typical insert to the tblTransactions:

INSERT INTO [TrackIT].[dbo].[tblTransactions]

...

Gave this a try to no avail:

USE [TrackIT]

GO

CREATE TRIGGER [dbo].[trDecrementBulkPurchases]

ON [dbo].[tblTransactions]

AFTER INSERT

AS

BEGIN

UPDATE [TrackIT].[dbo].[tblBulkPurchases]

SET [Quantity_Remaining] = [Quantity_Remaining] - 1

WHERE Transaction_Type = 'From Bulk Assignment' AND

[tblBulkPurchases].[PO_Number]...

Now it is working flawlessly by replacing the qualifiers with INSERTED. ... thanks all!

I'm getting the following error for each field of the tblTransactions when I try to execute the T-SQL to create the trigger:

Msg 4104, Level 16, State 1, Procedure trPopulateBulkPurchases, Line...