Hi all,

I was looking at this thread and hoped that another answer would come up. I
have a grid as my main access to data which has lookup in other tables. In
order to use the sort feature in the grid I took the following steps.

The Query Is

SELECT CONTACT_ID
, COMPANYNAME , LNAME , FNAME , COMPANY_ID , LANGUAGE
, SALUTATION_SHORT , SALUTATION_LONG , TITLE1
, TITLE2 , IS_ACTIVE , DELIVERY_PREFERENCE
, LAST_UPDATE , UPDATED_BY , REFERENCE
, ENTRY_TYPE , BRP1 , BRP2 , BRP3 , BRP4
FROM CONTACTS
JOIN BRP1LIST ON BRP1LIST.BRP_ID = CONTACTS.BRP1_ID
JOIN BRP2LIST ON BRP2LIST.BRP_ID = CONTACTS.BRP2_ID
JOIN BRP3LIST ON BRP3LIST.BRP_ID = CONTACTS.BRP3_ID
JOIN BRP4LIST ON BRP4LIST.BRP_ID = CONTACTS.BRP4_ID
LEFT JOIN LANGUAGELIST ON LANGUAGELIST.LANGUAGE_ID = CONTACTS.LANGUAGE_ID
LEFT JOIN COMPANY ON COMPANY.COMPANY_ID = CONTACTS.COMPANY_ID

And set the ordering Items to

Company=COMPANYNAME;COMPANYNAME DESC
Last_Name=LNAME;LNAME DESC
First_Name=FNAME;FNAME DESC
BRP_1=BRP1;BRP1 DESC
BRP_2=BRP2;BRP2 DESC
BRP_3=BRP3;BRP3 DESC
BRP_4=BRP4;BRP4 DESC

And Ordering Links to

COMPANYNAME=ITEM=1
LNAME=ITEM=2
FNAME=ITEM=3
BRP1=ITEM=4
BRP2=ITEM=5
BRP3=ITEM=6
BRP4=ITEM=7

This make the data uneditable from the grid but lets the user sort as he
wants to, these were the steps shown in the Getting started guide (Which by
the way is A1+).

The big question I have is: I there a way to get the same feature (sort)
using no join but in order to get an editable dataset ?

TIA