Bit of a problem has arisen with the searching on my database.

I have a separate search layout. For example go there to search for surname "Stoyles" doesn'r exist however "Stoyle" does exist. What I would like to do is trim the surname everytime one is entered.

right(SurName, length(SurName)-1)

Would the best approach to write in another search criteria if the nothing is found? (although not sure how to write values from a search to another files field so I can trim off)

Any ideas on this kicking about would be most helpful

Thanks

My approach to this is to use a filtered portal to show names, then a button in the portal row takes user to the desired layout.

I have been using a method called "TypeAhead" by John Mark Osborne. http://www.databasepros.com

This way the user can find a name by typing only a few characters.

I have the same setup search in my database but the user here seeem to prefer the standard search except when they are adding people.

So I ideally want a solution with involves that searching.

However with the type ahead is it possible if you type in "Stoyles" for it to be changed so this whould show "Stoyle" too?

Thanks

Hi Simon,

Take a look at this file Alphabet Filter By: John Mark Osborne URL:

http://www.databasepros.com

and this file AlphaJump By: Don Wieland URL:

http://www.fmfiles.com/tnt8.html

I have used both.

Lee

For a database of 10,000 names this really isn't any helpful.

Its not the problem of there being too many entries to look through the problem is that if search for "Stoyles" won't give me returns which show people with the surname "Stoyle" which is really want I want to achieve!?

Any ideas??

Thanks