Steve S Posted April 17, 2003 Share Posted April 17, 2003 k.. I've searched the forums and found a few posts on just this topic, but i must be missing some fundamentl understanding of scripting. here's what i want to do. I have fields A, B, C, and D on a layout. I want to put a FIND ALL field on the layout where the user can enter what they want, click a button, and all the fields(a to d) are searched with the entry. Now, I set up a CalcALL field that puts these all together into one searchable field. what i'm missing is how to tell the script to take the data in the FIND ALL field and use it to search the CalcALL field. I hope this makes sense, and sorry if this is basic. thanks Steve Link to comment Share on other sites More sharing options...
LiveOak Posted April 17, 2003 Share Posted April 17, 2003 First, The "FIND ALL" field MUST be a global fields or its contents won't be available for use when in Find mode. Enter Find Mode[] SetField[CalcAll, FIND ALL] Perform Find[] Without the CalcALL field: Enter Find Mode[] SetField[A, FIND ALL] New Record/Request/Page SetField[b, FIND ALL] New Record/Request/Page SetField[C, FIND ALL] New Record/Request/Page SetField[D, FIND ALL] Perform Find[] New request are "OR'ed", without the New Request steps, a record would have to match all four fields at the same time to be found. -bd Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 18, 2003 Share Posted April 18, 2003 Hi, depending on how large is the db, and if fields A to B are - indexed fields, - of same format (but this is also true for the Perfor find script), you could also use some kind of relationships here. 1.Create a stored calculation Multi-key = "field A" & " Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7841 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