Input the search criteria in a global field. In your Find Script, first empty this global, then pause the script. After the input, perform the find behind the scenes. When it comes to adding a record, set FIELD 1 to the content of the global.
Thanks for the response, it did get me to approach the problem from a new angle, but I guess I do not understand search all that well.
I created a global field that is used for the search criteria input, but the field I wish to search is not the global field. How do I use the global data to search the calculated field [field1] & [field2] & [etc.] I would copy and paste my script here but this site apparently does not allow pasting to the message base.
I was able to set [field1] = [global_Search_Criteria] when adding a new record using the script so now I just need to know how to take the search criteria and have is seach the correct field.
Any additional help is appreciated.
You can paste text to this forum, though you may have to click the clipboard icon with the w in order to do so. You can't, however, copy script steps directly from filemaker and paste them. To copy/paste a script, you can print a PDF of your script and copy the text from the PDF or you can use filemaker advanced to create a database design report and copy the text from there.
To use a global field in a scripted find:
Enter Find Mode
Set field[YourTable::YOurfieldyouwanttosearch; YourTable::YourGlobalField]
You can also include operators like:
Set field[YourTable::YOurfieldyouwanttosearch; "==" & YourTable::YourGlobalField]
I played a bit after my last post and figure out where I needed to correct my script. When you work seven days a week, it doesn't leave much time to think. I write these apps all the time, use them and forget what I did to make it work. Then I get an idea for another app and I have to research my older apps or read to find out what I need to do.