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.