BEGINNER!!SEARCHES THROUGH MANY FIELDS

[ginelli]

Hello, got stuck on the following problem:
I have several fields in which I will enter names of clients(defined as 'client 1 Studio 1', 'Client 2 Studio 1', etc.). I will need to do searches for a specific name of a client in the first field, then, if not found, in the second field, and so on (throughout the 42 fields I created!). I probably need to create a script to do that but I'm afraid that goes beyond my expertise... Can anybody help?Thank you.

 

[QaptainQwerty]

How about creating a calculated field that is a concatenation of all 42 fields and then search in that one calculated field. The search won't tell you which of the 42 fields hold the match but if you have a layout that shows all 42 fields then you can eyeball the fields. FYI, concatenation is done with the & symbol.