> Now any fields which are not 1 word are never applied
> to the main table when it is selected. I have not tested
> something like 'lave vaisselle' (without the -). But
> even as such I would like to use the -. Is it something
> I can't do, use the - or ' ?

This sounds like it may be the result of differences between the
character sort order between Interbase and Windows.

With character set = NONE Interbase gives the order:
A NAME
A$NAME
A-NAME
AANAME
AZNAME
A_NAME

On the other hand Win2K (Locale English (Australia)) gives:
A NAME
A$NAME
A_NAMe
AANAME
A-NAME
AZNAME


Note: Windows experiment done by placing the entries a standardd
TListBox and setting Sorted=true. Further experiments shows windows
windows sorting the '-' between M and N. I really dont know what the
logic is behind this.


IBO provides OnCustomCompareStr and OnCustomCompareText event handlers
on the TIB_Connection component so that you can override the string
comparisons done in windows to match that of the data returned by
Interbase.

Alternatively you can experiement with different character sets in
Interbase to see if you can find something that matches Windows.

Alternatively, if you are already using an uppercase duplicate field,
you could use a UDF to not only uppercase but also strip special
characters and replace with spaces (which I think should give you a
more consistent result).


HTH

Geoff Worboys
Telesis Computing