May be

...
   SKIP &&& forward
   IF EOF()
      SKIP -1
      MESSAGEBOX('END of table')
   ENDIF
...

...
   SKIP -1 &&& backward
   IF BOF()
      SKIP 1
      MESSAGEBOX('Beginning of table')
   ENDIF
...

>Our code performs on the skip logic on the parent table, so that the pointer to the child table is automatically reset to the matching record.
>
>>Which table parent or child ?
>>
>>>sorry, meant to say
>>>
>>>The code does not work when the table is EOF(), !BOF(), reccount() = 0
>>>
>>>
>>>>We have several SET RELATION in our code. Then they move the record pointer to establish the relation in the child table. The code does not work when the table is EOF() but !EOF(). This seems like an easy one but it is hurting my brain.
>>>>
>>

IF .NOT. EOF()
>>   SKIP
>>   SKIP -1
>>ELSE
>>   IF !BOF()
>>      SKIP -1
>>      SKIP
>>   ENDIF
>>ENDIF