Not to mention the last sentence in the VFP Help for the LOOKUP() function is:
This function can't be optimized with Rushmore.
>Andy,
>
>You can index on LOOKUP(), but Mark's answer is much better.
>
>Even so, if you aren't familiar with LOOKUP() it's a great function!
>
>
>>Hi all
>>
>>I have a parent table with a field that hold the ID from a LOOKUP table so that in a browse window I can set the parent relation into the LOOKUP table and display what the ID represents.
>>
>>EXAMPLE: '0001' is 'EAST', '0002' is 'WEST', '0003' is 'NORTH' etc...
>>
>>In the browse I want to set the order by the column which gets its content from the LOOKUP table and order the parent table accordingly.
>>
>>Can anyone tell me what is the best way to do this.
>>
>>Thanks much in advance.
Mark McCasland
Midlothian, TX USA