>I realize now that due to the nature of the fields I'm using to create the compound index I'm not going to get it to sort properly. The first is an integer, the second a date. If I convert them to strings in order to concatenate them, the dates won't sort correctly: "05/01/2000" comes before "06/01/1999". So I'm reluctantly going back to using a view.
>
>Thanks for everyone's help,
>Menachem
Well, there is nothing wrong with using a view. But DTOS will convert a data to string in a manner that sorts properly. So will Dtoc(date,1). So your INDEX expression would be STR(ln_int_key,10,0)+DTOS(DATE). Your linking expression would be str(LN_INT_KEY,10,0).
For this to work exact would have to be off.
Thanks
Gar W. Lipow