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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only