I need some opinions on how to do something. This is what I need to do.
I have two tables (Table1, Table2). I import a single list of numbers into a temperary table (TempTable). Table1 and Table2 have a 1 to many relationship. Table1 being the 1 and Table2 being the many. I need to take the imported list of numbers and add another unique Index from the form to the list. Then compair the list to Table2. If the number and Index already exist in Table2 then ignore, but if it does not exist I need to add it to Table2. If number and Index gets added to Table2 then I need to find the number in Table1 and write "ON HOLD" in a status field.
Table1:
Number Status
1231 ON HOLD
1232
1233 <--------Needs to say ON HOLD
1234 ON HOLD
Table2:
Number Index
1231 3
1232 3
<-----Will Be Added from TempTable
1234 3
TempTable:
Number Index
1231 3
1232 3
1233 3 <-----NEW
1234 3
So, what is the best method for a slow network to handle this?
I have two tables (Table1, Table2). I import a single list of numbers into a temperary table (TempTable). Table1 and Table2 have a 1 to many relationship. Table1 being the 1 and Table2 being the many. I need to take the imported list of numbers and add another unique Index from the form to the list. Then compair the list to Table2. If the number and Index already exist in Table2 then ignore, but if it does not exist I need to add it to Table2. If number and Index gets added to Table2 then I need to find the number in Table1 and write "ON HOLD" in a status field.
Table1:
Number Status
1231 ON HOLD
1232
1233 <--------Needs to say ON HOLD
1234 ON HOLD
Table2:
Number Index
1231 3
1232 3
<-----Will Be Added from TempTable
1234 3
TempTable:
Number Index
1231 3
1232 3
1233 3 <-----NEW
1234 3
So, what is the best method for a slow network to handle this?