I have a customer table with Customer ID, state customer belongs, Sales Rep and Sales Region of the customer. I am trying to get an update/insert logic working. What I am trying is to get to is -
If an existing customer comes in with a change in the state then –> Change State and void Sales Rep and Region
If an existing customer comes with same state information then –> No action
If a new customer comes in then –> Insert the customer to the table
Here is the data format
Looking for help in achieving this
Solved! Go to Solution.