I don’t know why I let looping through a table get me all tied up in knots but I do.
I have a particular problem that I know a loop will help me solve but have absolutely no idea how to write it in code.
Here is what I want to do.
I have two tables that I want to update the value in one table with a number + one of whatever the max is in the other table.
Here is an example
IN TableA there is a field that is an int value Call it PERSNO.
There is also a corresponding field in TABLEB that is int value.
I want to take the MAX value in TABLEA and where there is a NULL VALUE in TABLEB update TABLEB with The max value of TABLEA + 1.
View Complete Post