Hi charlie,

Isn't it possible to modify the SPT in such way it includes the last_name ? Are you using SQL 7 ? Then you might be able to make a view out of the SPT and use a normal P-view to include the last_name in a seperate view on top of that one.

Walter,

>Hi Walter:
>
>I should have been more specific. These are SPT cursors returned via ODBC from SQL Server SP's. Once they arrive at the client, I set up the proper indexes so I can relate the tables. I need to create some sort of compound index, like STR(foreign_key) + last_name so the child records will appear to be sorted by last_name and still maintain the relation. Need to know if there is a better way to do this.
>
>Charlie