I want to search a value list so that when the user enters the first alphabet of the word it shows all the items from the list with the first alphabet and then when he enters the second it searches for combination of first and secod alphabet and so on.Is it possible to be done using file maker.

Thank You

FM does this automatically for fields defined with a value list display as a "pop-up list". It does not show only those items matching the letters you type, but will move to the first matching item as you type the letters.

-bd

Maybe I am doing something wrong here.If I type in an alphabet the valuelist does not filter to the items with the starting alphabet.It doesn't do anything other than you select from a list.

It sounds like you want "type-ahead". It can be done in FMP, it's not that difficult but it's a bit of work and requires quite a bit of knowledge.

There used to be a sample file on the www.databasepros.com web site under the name "clairvoiance."

It's there under the "Resources" section, on page 6. Look again.

Sorry,Couldn't find the solution in that site.If you could give me an idea of how its done I could try it out.

Thank You

Welll I have found a letter filer example at http://www.databasepros.com/FMPro?-db=resources.fp5&-format=list.html&-lay=cgi&-sortfield=new&-sortfield=rating&-sortfield=creation%5fdate&-sortorder=descend&category=tip%20file&re leased=1&-max=5&-find=&-Skip=25

I don't know if this is what you are talking abt,but I am still searching for a solution to my problem

Well I have found a solution to this I created a related file and used the relation for the value list.The realtion would be based on a Calculation field using left(valuelistfield,1).So it filters the item starting with the first letter.I am just wondering if there is a way it just pops with out click on the field while just entering the data