Is there any way to program a search so that it only searches the first letter of each record. For example at the moment when I search for companies beginning with 'I' in my database I get 'Aggregate Industries' because of the 'I' in the second word. Is there anyway to stop this?

Thanks.

Hi, brooks!

Creat calculated field=Left(Your_Text,1) and serch by it.

This is one of ways.

In Find Mode, you can enter the following:

==A*

A being the first letter you are looking for

Hope that helps ???

Thanks for your help, but is there not a way that users can simply enter 'A' and find every result beginning with 'A' instead of results that have 'A' at the start of their second word?

Thanks.

...Im pretty sure that does, but if it doesn't... add an additional unstored calc field, make it leftwords(yourtable::yourfield ; 1) and then search that.

Hi Genx, that was already suggested by aaa.

Hi S. Brooks , and welcome to the Forum.

Upgrade to v8, and use the Auto-Complete, It works in Find Mode.

Do a search of the Forum for Clairvoyant or Typeahead (there are a few workarounds done in versions as early as 3)

Also, search Database Pros Web Site

Prior to v8, I preferred using a script for this attached to buttons, here are a couple example files.

AlphaJump By: Don Wieland URL:

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

Alphabet Filter By: John Mark Osborne URL:

http://www.databasepros.com/resources.html

AlphaDex By: The Alchemy Group URL:

http://www.alchemy-group.com/alchemy.html

Lee

Edited August 10, 200619 yr by Guest