Newbies evrythingsgonegreen Posted January 7, 2001 Newbies Share Posted January 7, 2001 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 Link to comment Share on other sites More sharing options...
Vaughan Posted January 7, 2001 Share Posted January 7, 2001 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. Link to comment Share on other sites More sharing options...
Newbies evrythingsgonegreen Posted January 8, 2001 Author Newbies Share Posted January 8, 2001 Thanks, Vaughan. That did the trick. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8508 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now