How to search a find word in a field?
For example, I have a "Item" filed: Bike 595-0008-5
If I only want to search 595-0008-5, what should I type in the Find mode?
Here are the different Operators you can use when using Find function in FileMaker
Refining find requests in FileMaker Pro using find operators | FileMaker
You may also want to implement some other features that may make life easier, like a search box with type ahead to dwindle down the possibilities, or have the fields you search use a value list based on values from that field.
Retrieving data ...