I've got a simple one-table-non-joined query which I'd like to order and
search on.

The query looks like this:
SELECT
CUST_ID, NAME, SURNAME, ID_NO, PHONE_H, PHONE_W, PHONE_CELL,
FAX, PH_ADDR_1, PH_ADDR_2, PH_ADDR_3, PH_ADDR_4, PH_CODE,
PO_ADDR_1, PO_ADDR_2, PO_ADDR_3, PO_ADDR_4, PO_CODE,
NOTES
FROM
CUSTOMERS

The TIB_Query .OrderingItems property is set to:
CUST_ID=CUST_ID;CUST_ID DESC
NAME=NAME;NAME DESC

The OrderingLinks property is set to:
CUST_ID=1
NAME=2

The OrderingItemNo property is set to 1.

I've done the sorting of tables plenty times now and for some reason the
sorting on the most simple query of them all doesn't want to work. What
other properties do I still need to set? The CUST_ID field is the table's
primary key. I also have a problem searching through the table but I think
once the sorting has been sorted out, the searching would also work.

Best Regards,
Don Schoeman