Create a Calculation Field - Last Name Initial (to deal with Von Neuman and such)
Create a Self Join Relationship LastNameInit >--< LastNameInit
Make 26 buttons with A thru Z search of LastNameInit - and portal with relationship.
A Rolodex for last name find.
Take a look at this sample apple. As you type a name it filters out the names that don't match. Click on the name in the list to take you to that record.
Thank you David and Chamblee
The ideas are wonderful, but I alredy have 3 fields and need to work with them.
I´m trying to write a script to omit records not matching with the field alredy filled.
The idea is to create something like web pages that when you choose the country, the next field automatically shows only states in this country.
Still not solved.. Ideas??
"The idea is to create something like web pages that when you choose the country, the next field automatically shows only states in this country"
That's a Conditional Value List. Search for that on this forum - lots and lots of hits...
Here are some links on conditional value lists:
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
Hierarchical Conditional Value lists: Conditional Value List Question
Here are some demo files that illustrate different script enhanced ways you can employ in FileMaker to better facilitate selecting from a list of names:
The last two links link to different copies of the same file. Select the link appropriate for your version of FileMaker. For the other download links, if you are using FileMaker 12, you can open them from the File Menu to convert them into .fmp12 format so that you can open and examine them.
Here is another sample app that expands on the first sample. I setup to use name or account number, which shows items in a portal. You select a the type search on a popup menu then you enter your search then it finds the related records in a portal. The portal filter down as you type. For Example if you type the letter D it shows all records with the last name that starts with D.
PhilModJunk, thank you a lot!!!
That´s exactly what I was looking for!!!
Chamblee, your last post was like Yoda!!
I finally decided to work in a Layout based on yours, but it´s quite complicated for me so it may take a time, I´m trying to figure out the steps to make it.
Thank you both!