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.