Hi David

Yes, I realise it is not the best. But I am wanting to display data in a particular order.

I have a customer table which has an optional link to a dealer table. I want to be able to order the customer table (in a grid) by the dealer name. Because of this I cannot use a one to many relationship.

I can create an index on the customer with an expression of

IIF(INDEXSEEK(d_key,.T.,"DEALER","D_KEY"),Dealer.name,SPACE(40))


>but then I have to have the dealer table open every time I want to use the customer table (including in the form designer) While I can do this, it seems messy.

The user needs to be able to select which order they want, most of which are on the customer table. I can create an external index each time I need to use the index but this also seems a bit messy.

Is there a better way???

Regards
Geoff,

>>I have found this is because I have a key field on a table which uses external data (data from another table).
>
>That's a very bad thing to do. It's also bad to use a UDF in an index expression.