>it is set up for an order by i dont think there is anyway i can set that index to a different one like that because doesnt the cdx handle the link with the parent table?

James,

Whether you use a CDX or an IDX makes no difference. You can always SET RELATION TO and SET SKIP TO to handle the relation. The CDX has nothing to do with the link to the parent table

HTH

Rex