I am on the process of migrating my database to SQL Server 2000.
My existing apps was developed in VFP8 and the Native VFP as its database.

Many of my existing forms uses the SET RELATION command to relate child tables.
Example:

sele department
set order to department

sele items
set rela to department into department

my problem is when is use SPT i need to index each cursor after the retrieval of the recordset if i need to relate it or issue a set order to
such as:

=SQLEXEC(pnhconn,”select * from department”,"department")
sele department
index on department tag department
set order to department

is there a way in VFP8 to automate this?

Many thanks