Generating an "OR" Find Script

[steamcarriage]

I'm having a heck of a time getting an "OR" find to work in scriptmaker. Perhaps someone can give me some help. I have four (4) fields of data that I need to search for a date code. Each of the four fields is text data relating to a production date for a given sub-assembly. I want to enter the text string I'm searching for in a field, hit a button that I have on the screen, and have it search the four fields for the text data that I've entered. It is easy to do manually by entering the FIND mode, entering the text in the first data field, then using the Requests menu and Add New Request to clear the page so that I can enter the same text data in the second field to be searched, and so on for the remaining 3 fields. I want to automate that with a button. Could someone give me the script format to do that? I've tried a lot of variations and can't get it to work.

Thanks in advance.

[Eric Crisp]

Well, just off the top of my head I would say create a global text field in which you enter the data you wish to find, say gFindData. Then create a script that runs when they click on a Find button you've put on the layout:

Enter Find mode

Set Field ["Field1", "gFindData"]

New Record/Request

Set Field ["Field2", "gFindData"]

New Record/Request

Set Field ["Field3", "gFindData"]

New Record/Request

Set Field ["Field4", "gFindData"]

Perform Find

Goto Layout ["Results"]

Something like that should get you what your trying to accomplish. Hope this helps!

Eric

[steamcarriage]

Eric,

Thanks for your assistance. When I saw what you proposed I corrected what I had accordingly and it works just perfectly. I've also learned what I was doing wrong. I knew it had to be possible but I couldn't seem to get it. Thanks so much for your help.

Bob (aka - SteamCarriage)

[Eric Crisp]

Bob,

No problem. Glad I could help!

Eric