Find does not work

[UpNorth]

I have a text field that is indexed and is a lookup. When trying to search this field majority of the time it does not work. The only time I've got it to work is when I've typed 1 or 10.

For other tables and files I have no problem search this type of field. The one thing that is different is that I'm only viewing active records. If they are marked inactive I search for them in the opening script and omit them from the viewed list. This occurs both with my script and when I use the filemaker search.

Any input would be greatly appreciated.

[Ugo DI LUCA]

Hi,

Where are you searching ? In a portal or "in the

record" itself ?

If it's the first, what is the relation established.

It's not clear enough what you're exactly doing.

[UpNorth]

It's in the record itself. No relationships.

[mr_vodka]

Have you tried to reindex this field? Turn off the index, save and then reindex.

[UpNorth]

I have the indexing turned off and now it's working. I can't restart the database until this evening, but I think this is looking promising!! ;)