Hello guys,

I have this relation tables question

I have 3 tables
I set the relations within them
table1 relate to table2 and table2 multi-relate(one to many) to table3

How do I go by scanning table3 results only. (table3 is 2000 rows) every
results is about 3-4 rows in table3,


@-- relations have been already set

sele table1
scan
sele table2
scan
sele table3
do while not in relation (of table2) <-- do not know if this works
do some process
skip
enddo
sele table2
endscan
sele table1
endscan

thanks

marcos oliva