You have to sort by the column's number in these cases, i.e. ORDER BY 3. I
think this is possible to specify instead of USER_NAME in the OrderLinks
property.

Set

At 09:45 09.01.2001 -0000, you wrote:

>I have two tables where I need to lookup some value from the second
>table to display in a grid alongside values from my primaty table.
>Everything works and the lookup displays the correct values. My
>problem is that I want to sort on the "looked up" values. My table
>looks as follows:
>
>SELECT SERIALNR
> , MODELNAME
> , (SELECT DISPLAYNAME FROM GEBRUIKERS WHERE
>GEBRUIKERS.INDEKS=STOCK.GEBRUIKER) AS USER_NAME
> ....
>
>If I set up the Orderlinks property to sort on the USER_NAME field, I
>get an error that the field does not exist. Am I doing something
>wrong or is it supposed to work this way.
>
>Johan Kotze
>
>
>
>
>