pradeep Posted October 22, 2001 Share Posted October 22, 2001 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 Link to comment Share on other sites More sharing options...
LiveOak Posted October 22, 2001 Share Posted October 22, 2001 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 Link to comment Share on other sites More sharing options...
pradeep Posted October 22, 2001 Author Share Posted October 22, 2001 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. Link to comment Share on other sites More sharing options...
Vaughan Posted October 22, 2001 Share Posted October 22, 2001 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." Link to comment Share on other sites More sharing options...
Vaughan Posted October 26, 2001 Share Posted October 26, 2001 It's there under the "Resources" section, on page 6. Look again. Link to comment Share on other sites More sharing options...
pradeep Posted October 26, 2001 Author Share Posted October 26, 2001 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 Link to comment Share on other sites More sharing options...
pradeep Posted October 30, 2001 Author Share Posted October 30, 2001 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 Link to comment Share on other sites More sharing options...
pradeep Posted October 31, 2001 Author Share Posted October 31, 2001 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8206 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now