>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.

Create a local view that joins the 2 tables and do an ORDER BY LookupTable.Descript Then use the view as the record source.