Hi Nadya,
I'll just comment them out, since they don't affect the overall functionality. I have not been able to look at it this evening at all...too much work to do. Perhaps I will get a chance tomorrow, but the best chance is Wednesday, since tomorrow is my anniversery with my wife, and I don't plan on staying here at work late :)
I do know that I usually use a little different loop structure for this type of situation. Something like this:
do while not eof('table1')
... set variables, etc...
if table1.currentAddress <> m.lcCurrentAddress
else
endif
skip in table1
enddo
The primary reason is that the control loop is based on an eof() check. I would want the change in that loop to occur at the very bottom, and don't prefer to have another (inner) loop that can affect that condition.
Talk to you tomorrow,
steve
>
>These are not important. You may comment these lines for now. If you want I'll send you Lookups database tomorrow (it's not that big anyway).
>
Steve Gibson