>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

---

Try Scan for Table3.field = table2.field