just check the autocomplete in that dropdown list then it'll coe directly.
I know how to set autocomplete to ON. But this doesnt work for the scenario in my orginal post.
You'd need to do some scripting that updates things keystroke by keystroke. I use a filtered portal in FileMaker 11 for this kind of thing.
- Make a portal to a table that lists all your possible values.
- Define this portal expression: PatternCount ( PortalTable::FullNameField ; YourTable::GlobalTextField )
- Place YourTable::GlobalTextField just above the portal and use an OnObjectModify script trigger to run this one line script:
- Refresh Window [Flush Cached Join Results]
- This step forces the filter on the portal to update with each keystroke.
- Place a button in the portal row or make the entire row of fields in the portal a button that then puts the value in that portal row into the desired field of your layout.
thanks PhilMod, ahh, I see that with FM 11, I am on 10 though.....
The portal can relate with the X operator so that all records in the value list table match all records in your main table. The portal filter then limits the list as you enter a more and more specific text pattern.
and I can do this with FM10?
No, the filter requires FileMaker 11. That's why I specified Filemaker 11 in my earlier post.
This isn't an easy approach to implement in FileMaker 10 as you can't filter portals and have to instead use a very complex calculation field and/or custom function (creating a custom function requires FileMaker Advanced), that breaks down the names into a long list of partial text values separated by returns that you use as a calculated key in the relationship.
"John Smith" for example, would need:
In that one caclulated key field.
List ( Left ( FirstName ; 1 ) ; Left ( FirstName ; 2 ) ; //and so forth ; FirstName ; Left ( lastName ; 1 ) ; //and so forth )