I am trying to create a perform find script where a person can perform a search based on one or two criteria. I am having issues cause either it finds everything or it replaces data with in my records. How can I fix this?

Post a copy of your script, or a copy of the file.

Lee

[color:purple]There are a lot of ways to do this -- it would be easier to answer if you were more specific. But I notice that you claim to be a "novice", so I'll just give you one of the simpler things to do.

You could set up a button to launch a script, and that script could then guide them to a layout where they can fill out a couple of fields where you've set up drop-down lists or checkboxes for the different choices they have (or allow them to fill something out freestyle).

I don't know how far you've gotten with FileMaker, but I assume you know how to make fields and layouts, since you're far enough along to have fields that can be searched.

So to make the script, you can go to the "Scripts" menu and choose "ScriptMaker", then click the "New" button. Then I'd create two scripts to keep it really simple for you & avoid the whole parameters & "If" statement thing:

[color:green]Script 1: Have the user go to the layout with the fields to use in the search, and enter find mode:

- Go to Layout (specify)

- Enter find mode (do not pause)

Script 2: Perform the find and return to the original layout

- Perform find (do not specify)

- Go to layout (name the original layout)

So you'd take these two simple scripts, and put a button on the layout where they'd start the find, and connect that button to Script 1. (To set up a button, go into layout mode and either use the button for buttons on the status bar to the left, or right-click the object you'd like to be a button and chose "Button Setup" -- then select the Script 1 you just made.)

Then on the screen where they fill out the two fields, put another button off to the side of the fields that is linked to Script 2.

There are many ways to make this task more sophisticated, but this is probably the easiest for a beginner.

Any help with making it more elaborate, post again for help!

:waytogo:

Thank you. I realized I tried to enter find and perform find on the same layout and that's why it wasn't working.