Pb with retrieving on portals using fmp7

[JK]

Hi,

Using a self relation from client table to client table for searching by alphabetical sort;

tow fields Filter(text) and Filter"Z"(caculation) and Name of clients.

Filter----------<=Name

Filter"Z"---------->=Name

This is working well foe rearchin on names; only when a name has Z in it by example FAWZI. This is not working if i search for FAW; but working when searching for F, FA, FAWZ, FAWZI an displays well all names bigning with theese.

Do you have an explication for this; and something to do to fix this search. thanks

[color:"blue"]

[Ender]

Can you specify exactly what you have in your calc field?

[JK]

Hi I find,

I have to add 2 Z to my filter fiels; this work find

Filter----------<=Name

Filter"ZZ"---------->=Name