Hi experts! I need to have an Insert/update trigger that can upate a column in a table2 that is based on a value of a column from another table1.
CustID, Account#, name, etc.
CustID, Account#, Order, etc.
When a new record is inserted into table2, I need to get the CustID value in Table1 for the Account# that matches the Account# from the Inserted record.