>>Something keeps moving my record pointer after a seek back to where it started (or maybe just to the top of the
>>table, since it always starts at the top).
>>
>>I put these two statements in the method where it happens.
>>
>> wait window str(recno('clients'))
>> wait window str(recno('clients'))
>>
>>
>>There are NO statements between the 2 wait windows, but the recno() changes.
>>
>>I can't even begin to figure out what's doing it, so I don't know what info might help someone else figure it
>>out.
>>
>>The only thing I can even imagine might have something to do with it is the relations:
>>(I'm leaving out all the normal syntax, just to show you the relations)
>>
>>select table2
>>set relation into table3
>>set skip to table3
>>
>>select clients
>>set relation into table2
>>set skip to table2, table3
>>
>>
>>HELP.
>>
>>TIA
>>
>>Bill
>
>Bill, have you walked through the code with DEBUG? Since you have relations, then it's probable THAT is the problem. When you SELECT a parent table, the record pointeron the child goes to the first record of the child tables.
>
>It looks like Client is your top-parent table here, but the relations may still be at fault. Can you use the tables without relations and use SEEK instead for the child tables?
>
>Barbara
I've done this. My next attempt was to do just what you're suggesing (remove the relations and do the seeks
individually), but I found something that manage to make it work. Maybe you can explain why.
Please see other thread (me replying to me)for what appears to work (although I can't figure out why).
Bill
Bill Morris