Search records using a field and portal

[OffTheDeepEnd.com]

So basically I am trying to display like records in the portal view based off the last name field as the user is keying. For example lets say there are three records in the client information database:

John Doe

John Doeter

John Doeteritz

As the user is keying D into the last name field it shows all three but as there are more characters keyed like doet, it would eliminate the first name since it would no longer match. Below is a screen shot of my layout but I can't think how I could create a like match using a relationship with possibly a wildcard.

Please let me know if you have any questions and any help is greatly appreciated.

[Vaughan]

The trick is the "exploded key" in the related table. It needs to have each potential match value as a separate value on a paragraph delimited list. The key for "Doeter" would be

d

do

doe

doet

doete

doeter

...

and so on for as many as you care to want to match.

[OffTheDeepEnd.com]

Thanks for the info. I ended using the ExplodedString and ExplodedKey functions. Works Great!