My client has an Access system that I am converting to FMP 6. In Access when the user types in a field an incremental search begins of the Value list i.e. A typed "M" shows the first of the M values, then typing an "i" shows the first Mi values and so one. I need to make this work in my Filemaker solution. Help!

Is there a programming technique, plug-in or another solution that you can think of? It may just be that I don't know what to call it in FMP. I would be glad to pay for a solution if I need to.

It must be somewhere, because it works in the FMP help system when I am

using the index.

Thanks,

Ben

You can do this with a relationship based upon a global field, related to a multikey generated from the field to be searched.

gSearch (global, text)

State (text)

MultikeyOfState (text, indexed)

Say you entered "Mi" into gSearch (and tabbed out).

The MultikeyOfState field for a State of "Michigan" would contain:

M

Mi

Mic

Mich

Michi

Michig

Michiga

Michigan

Each of these values is separated by a carriage return.

This multikey can be generated with a calculation, script, or plug-in. The resultant matches could be displayed in a portal or as a value list based upon this relationship.

-bd

Excuse my ignorance, but this is the UFO forum. How is that solution resolved online? What am I missing?

BenGarber, excuse me but I have a similar problem that is rewriting an MSAccess project into FMaker. I am just searching solution to this situation. Would you pls help me with this? If yes, pls email me. [email protected]