I need to write code to be able move one row into a possible three different tables.
I need to check and see if one field from the row in tableNew matches the same specific field in any of the rows in table1.
1)If not, move row to table1.
2)If so, move row to table2.
3)If empty, move row to table3.
In addition, I need to able to write this code as a loop because there are multiple rows in tableNew that need to be evaluated. Thanks.