Hi everyone,

I have a portal with around 2000 records in it, sorted alphabetically . What I'd like to do is put a search field above the portal where I can enter a few letters from the name of one of the records and have the portal only show records that start with those letters. Like if a record I wanted to find was called "Anderson", I would just enter "and" and the portal would only show records that started with that. This would let me narrow the portal down and quickly find the record I'm looking for.

I saw another post that suggested using a global field as the search field and using that in a relationship to the name of the record. However, I think that would only work if the user entered the entire name of the record, which can be quite long. Any ideas would be greatly appreciated!

Here is a quick and dirty way to do it. It has some limitations but it should get you what you are looking for...

Use a global field called gFilter for your user to enter in data.

Create a calc such as the following (cFilter):

Case ( IsEmpty ( gFilter ); "0¶zzzzz"; gFilter & ¶ & gFilter & "zzzzz" )

Then you can make your relationship keyed as such:

cFilter ≥ Name

cFilter ≤ Name

This will allow you to do filter portal.

Excellent. Works great! Thanks for the help.