Sorry for such a late response, but i'm the owner of my firm (wich is a very
very small firm of software development)
and i have too many things on my head including developing the software, so
i'm a very "hard to find" person.

""Geoff Worboys"" <geoff@...> wrote in message
news:008101c122dd$75a0e500$0201950a@hex...

> Pirtea,
>
> You are talking about the the AutoLabel of the TIB_LookupCombo
> control? If so then I made some recent (IBO_4_2_Ea) changes to how
> that operates in order that it would go bold when the foreign key was
> required (and also to make it label respond more dynamically). I
> thought I was still showing the DisplayField name as the label but
> perhaps I've got something wrong somewhere.
>

Yes, i'm talking about the lookupcombo label, but you know i'm very new to
IBO
so i'm not completely sure that this "feature" wasn't there before the bold
change
Let's say i'm 90% sure it wasn't there. the problem appears only with
lookupcombo
and only for queries containing joins.

> If you can reproduce the problem in a sample app please send to me.
>

I'l try and make a demo app for tomorow. My query is something like
this (in case it helps without the demo)

"select a.id,
a.field1,
b.field2,
c.field3,
d.field4
from table1 a
join table2 b on a.id_table2=b.id
join table3 c on b.id_table3=c.id
join table4 d on c.id_table4=d.id
"
ordered by field3

the order by is included automaticaly by ibo
it looks like this

a where clause on field3 to trik IB to use an index on that field
and then order by field3

just as i would do it

the resulted plan is perfect (what i want)
and the resulted query just as expected

then i set the display field on the lookupcombo (it should use the ordering
field by default)
to the field3 the label displays instead of my field "table4"


Regards,
Pirtea Calin.