I'm going nuts!

[evrythingsgonegreen]

Hi,

I'm a FMP for Mac 4.0 user. I've been trying for the longest time to figure out how to set up my database to search all fields for a text string I input and return all records that have a match. I've tried both scripting and the use of a relationship/portal, and I'm just not getting anywhere. I would guess that this is a fairly routine type of exercise for someone a little more familiar with the application. Can someone tell me if scripting is the way to approach this problem? or is setting up some kind of relational DB / portal the way to go? Perhaps some combination of the two? I would be most appreciative of any advice.

Thanks

[Vaughan]

Make a calculation field in the db that joins up all the text field you want to search on, then perform the search on the new field.

[evrythingsgonegreen]

Thanks, Vaughan. That did the trick.