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.
May all your weeds be wildflowers