1. You don't do this in SQL, you would join your tables so the related data is on each record.

2. With SQL server you can only specify an index using query hints. IF you want your record set in a certain order, add an ORDER BY clause to your query. If you are using Remote Views you can index the view after it retrieves the data.

BOb


>Hi All
>
>Can anyone help with these please
>
>1. In a VFP front-end and VFP back-end i can set RELATIONS in the data environment. How do i this in a SQL 6.5 back-end using VIEWS??
>
>2. In a vfp back-end I can say e.g. SET ORDER TO TAG "ASNUM"
>How do I do this using a SQL backend??
>
>
>Thanks in advance
>Fida