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

Here's a typical insert to the tblTransactions:

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

([Buyer_Initial]

,[PO_Number]

,[Software_ID]

,[Transaction_Number]

,[Transaction_Type])

VALUES

('OCC',

'5465115',

'51',

17901,

'From Bulk Assignment')

GO