Use D* as your search parameter
Thank you for your response.
The parameter that needs to pass to make that work is ==D*
Works fine for me without "==". Does not make sense to include match the whole field operator with a wild card. You obviously testing it on your data set and you requirements are probably wider than your sample. In any case, I am glad your fond your answer
The FileMaker finds by default using "begins with" and for any word in a field. When doing multiple words (an AND find in a single field) the order of the words need not even matter!
Find ("J B") would find both "James Butler" & "Butler, James", for example.
Using a single character followed by the asterisk wildcard would be the same as "begins with" (anywhere in the field) followed by ZERO OR MORE CHARACTERS.
The ==<<singlecharacter>>* does work with the START of the field.
In any find the case of the character doesn't matter, but accented characters do. Lot's of things to learn about Finds in FileMaker!
Does not make sense to include match the whole field operator with a wild card.
Given three records with "J", "John" and "John Smith"
- J* and =J* will both find all three records
- ==J* will find J and John, but NOT John Smith
- ==J will find only J
Twice in one day: FWIW: FileMaker Power Finds | Extensitech
You are absolutely right, Chris - I stand corrected. It does matter and it matches the OP better.
Create a global field (text) called First_of_search
Create the field (text) you want to do the find in: Call it Last_name
Create a calc field named First_of_Last = Left ( LastName ; 1 )
Create a calc field named they_are_equal = [ First_of_last=First_of_search ]
In the layout, where u want to do the Find, put the First_of_search field somwhere in the body part - and of course also the field Last_name.
Create a script called find_equal
enter browse mode
Perform Find [Restore] ---- Find Records filename: they_are_equal [=1]
Sort Records [Restore; no dialog] (alpha or whatever)
View As [View As List]
Go to Record/Request/Page [First]
In Layout Mode select the field First_of_search
In the layout menu select Set Tab Order
Select field First_of_search
Set Script Trigger
√ OnObjectModify "Find_equal"
From then on all you have to do upon entering this layout in Browse Mode is:
Press TAB then enter the letter you want to search / find with.
e.g. Tab > a or A gives:
Allthatcounts etc, etc