>you can make the relation on the index+the order index or create a compound
>index with the relation index and the order index) or create a view/cursor
>for the many side
>
>btw, why don't you use the DE?

Thanks Arnon.

I am not using the DE, because I am maintaining a "legacy app" (2 years old ha!). Which was designed with VFP, but using mainly FP2.6 techniques such as the rule "open all of your tables at the start.

I have created several small apps using the DE, and it sure simplifies things.