Posted by Mr Smith on 10/02/13 11:52

I have not tried it yet, but.

I need to open a table, look at every row of data. Then select a
particular field every time, get its contents. Then do a search for
that value in another table (in the same database), than return
another value from the searched rows fields.

From that returned value do the same again in another table (in the
same database), and return another value.

Then do a bit of calculations etc

Then go back and look at the next row in the original table, and
repeat again until the end.

[Back to original message]