Hello, could someone help me, please?
I am wanting to create a SQL Trigger for the following.
When a new sales order is created in the TRANSHEADERS Table where AccountCode = ‘Customer’
I want the following script to trigger.
Set Customers.ZCustref = Transheaders.ExtraText
FROM CUSTOMERS INNER JOIN
TRANSHEADERS ON CUSTOMERS.UniqueID = TRANSHEADERS.AccountID
Where Customers.CustomerCode = 'Customer'
I have tested the script and it works as I want.