You really want to have relationships based on proper key fields with a UUID.
It sounds like you can do this with some dynamic portal filtering rather than a find.
I've found a custom function that works with portal filtering quite well, you specify your filter field and a list of all the fields you want to filter against. It works pretty well. I forget where I found it, but if I can put a quick example together I'll post it. It likely won't be for a day or two though.
I currently don't have it doing a find. I have a relationship set up between the two tables, global fields on the Menu table related to the fields on the client table. On the layout those global fields are there and when you type info into the three fields it brings up the record. The problem is it needs all of the fields completed to find matches, where I'm looking to find based on one, two or three of them completed to allow for more results/checking other possibilities based on imporoper data entry.
I'd really appreciate that David, thank you. Sounds like what I'm looking for.
Turns out it won't take a day or two. I'm sitting in a hospital waiting room for a family member and it turns out FileMaker is a welcome distraction. This was easier to concentrate on than real work.
The CF was from the Scarpetta Group. The technique consists of...
1 custom function
1 named portal that is filtered
1 script trigger, on your search field
The file has 5000 records in it. It only filters on first and last names in the example, you can add more in the portal filter setup. The larger the record set and the more fields you filter on the slower it will get. I seem to recall it has issues with mixed text and number fields (like an address or zip/postal code).
I've been using it on portals with about 300 records and 5 or 6 filterable fields. The performance is fine with that.
Hope it helps.
Portal Filter.fmp12.zip 358.7 K
Thank you SOOO much! Exactly what I needed!
By the by....I hope your family member is ok!!