>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only