Dear all,

I used IB_Connection.FieldsDisplayLabel to set the grid column title
globally, like that:

Brand.Name=Brand
Category.Name=Category
Currency.Name=Currency
Package.Name=Package
Unit.Name=Unit


It worked like a charm. So I didn't bother to name the fields in all
queries, like that:

SELECT P.ID
, P.PN
, B.NAME
, K.NAME
, C.NAME
, P.PHY_QTY
, U.NAME

FROM PRODUCT P
LEFT OUTER JOIN BRAND B ON B.ID = P.BRAND_ID
LEFT OUTER JOIN PACKAGE K ON K.ID = P.PACKAGE_ID
LEFT OUTER JOIN CATEGORY C ON C.ID = P.CATEGORY_ID
LEFT OUTER JOIN UNIT U ON U.ID = P.UNIT_ID

However, when I come to setup Ordering for the queries, it doesn't
work becuase of the same 'NAME' fields!

Is there a workaround? Could you save me from rewriting all qeries,
please?

TIA,
Michael