--- In IBObjects@y..., Geoff Worboys <geoff@t...> wrote:

>
> OrderingItems:
> Employee Dept=EMPLOYEE.DEPT_NO
> Department=DEPARTMENT.DEPT_NO
>
> OrderingLinks:
> EMPLOYEE.DEPT_NO=1
> DEPARTMENT.DEPT_NO=2
>
> FieldsDisplayLabel:
> DEPARTMENT.DEPT_NO=Dept No
> EMPLOYEE.DEPT_NO=Empl Dept

Now I see the problem. In my query, I had table aliases, so I put
the same table alias in the OrderingItems and OrderingLinks
property. If I put in the full table name, then it works. Somehow
or other, IBO resolved it all.

Guess I would have to use the FieldDisplayLabel property and ditch
the inline aliases.

Thanks for your help and patience.

Regards
Ray