I am having a problem relating updation of a field.
i have a table A which has a column A.1 which is unique but not autonumbered. i take the value
for this column from another table B . i want to copy particular records from table A into a new table
C then do the updations on column c.1 and then move back the records from table C to table A .
This column C.1 is causing me problems. what is want is
1-update the first record of C.1 with the value of table B
2-update the table B to the next value
3-update the second record of C.1 with the updated value of table B
and so on
looks like a foor loop to me but i just cant figure it out