skipping records in a child table

[benny7]

I have two tables with a one to many relationship. Currently I've linked them as below:

select 0
use shares && child
set order to client
select 0
use client && Parent
set relation to client.sysref into shares
set order to sysref
seek 101

The shares table can have many records associated with the client table. I want to skip 1 record at a time in the child table, but only for the client record selected. Is there a way I can do it without skipping one and checking the linked fields still match?

 

[StewartUK]

I would select into shares and use a SCAN WHILE loop to go through all the child records.

By the way, another way of opening the tables would be to open the client table first and then execute the line

use shares in 0 order client

Hope that helps,

Stewart
PS If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[ezopaci]

You can use SET SKIP TO relation. Read about it in help.
SET RELATION is ONE to ONE relation (i hope), then SET SKIP makes ONE to MANY.