>Some code was written for a client where two tables were joined using a "set relation to". Everything is fine except the records are not printing in the right order because of the "set index" command that precedes the relation command. Is there a way to set the order such that it prints right or do I have to use a SQL statement and put the records into a cursor before printing?

If you set order to a valid key for the realtion it'd work, however you might also need to set skip.
Creating a cursor instead is easier IMHO.
Cetin