filtered portal ala spotlight

I would like to create a filtered portal that behaves like spotlight
in OS X.

My solution has one table for events and join table for members
registered in events.

On a event layout I display the names of registered members in the
join table (RegisteredEvents)

I would like to be able to type in a field on the layout and as I type
the portal filters based on last name.

Ex:

User types S and the portal filters to all last names beginning with
S.
User types Sm and they get Smith, Smithers, etc

I'd like this to happen in real type, while the user types. Is this
possible in FMP 9.0, or does the field need to be committed?

Darren

Re: filtered portal ala spotlight

In article <1192317607.072519.304340@i13g2000prf.googlegroups.com>,
Darren wrote:

> I would like to create a filtered portal that behaves like spotlight
> in OS X.
>
> My solution has one table for events and join table for members
> registered in events.
>
> On a event layout I display the names of registered members in the
> join table (RegisteredEvents)
>
> I would like to be able to type in a field on the layout and as I type
> the portal filters based on last name.
>
> Ex:
>
> User types S and the portal filters to all last names beginning with
> S.
> User types Sm and they get Smith, Smithers, etc
>
> I'd like this to happen in real type, while the user types. Is this
> possible in FMP 9.0, or does the field need to be committed?

The data has to be committed / field exited for a relationship to
work, so it will probably be the developer and users that need to be
"comitted" if you try to work around that. ;o)

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)