hello Helen,

thank you for your reply.

> > 'SHORT_NAME=UPPER')
>
> OK!! - why do you need to enforce uppercase on
> this? If it is because you are storing lowercase
> in one place and uppercase in another, then that
> would explain why the incremental search misbehaves.
>
> The keylink relationship won't work if there is
> uppercase on one side and lowercase on the other.
> The FieldsCharCase is a display property, not a
> data one.

ok, the field SHORT_NAME in the database is already stored all in upper case,
but I have noticed that not defining FieldsCharCase when I type into the
TIB_LookupCombo, characters are entered in lower case.

Well, I have made some testing:

I have removed the FieldsCharCase definition and characters are now entered in
lower case and of course nothing is found in PROVINCES. Doubled characters RE RA
are not visible because it founds nothing, but the problem with the drop down
list that doesn't allow me to make a second selection remains. But attention, if
now I type with Shift pressed the problem is exactly the same with doubled
characters RE RA and I still cannot select from the drop down list.

So, how to correctly type in upper case in the combo without having to keep
Shift pressed and correctly search?

I have also to say that the same FieldsCharCase definition works well into
another form where I use an TIB_SearchPanel.

BTW: Firebird Book is arrived and is impressive, congratulations! Now we need
that you write another one on IBO :-)

Cheers
Salvatore