Jump to content
Sign in to follow this  
pradeep

Seaching Using Pop Up List

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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."

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.