I have a IB_Query which links up with 3 different table and setup
the orderingitems accordingly. However the orderingitems does'nt
seem to work. Please help.

SELECT H.REFNO
, A.NAME
, A.STROKE
, A.S_CODE
, H.DOSAGE
, H.CHARACTERISTIC
, H.SYSTEM
, H.FUNC
, H.USES
, H.REMARK
FROM HERBAL H
RIGHT JOIN HERBAL_WITH_CAT HC
ON HC.H_REFNO = H.REFNO
JOIN ALL_HERBAL A
ON A.REFNO = H.REFNO

The Plan is:
PLAN MERGE (SORT (A ORDER X_ALL_HERBAL_SCODE),SORT (JOIN (HC
NATURAL,H INDEX (RDB$PRIMARY3))))

The Keylinks are HERBAL.REFNO and ALL_HERBAL.NAME which is the
primary key for table HERBAL and table ALL_HERBAL respectively.

The OrderingItems is:
HERBAL_NAME=ALL_HERBAL.NAME
H_STROKE=ALL_HERBAL.STROKE
H_CODE=ALL_HERBAL.S_CODE

The OrderingLinks is:
NAME=ITEM=1
STROKE=ITEM=2
S_CODE=ITEM=3

The OrderingItemNo is 3.

When I open the dataset inside IB_Query editor, the data display
propertly but when I click the data grid title on one of the
ordering fields to change the ordering, nothing happen but I can
still see the glyph is displayed next to it. What's wrong?

I am using Firebird 1.0 and IBObjects 4.2.Ia.

Regards,
Kenneth Man