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