Hi Steve,
I think, you're right again. I will make the necessary changes. I will keep you updating with my progress.
>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
> * start new group of records
> else
> * do things for continuing on same group of records
> 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).
>>
If it's not broken, fix it until it is.
My Blog