Figure 1: Worlds collide! -- Robert Smith and Patty Smythe may never occupy the same room, but you can have them in the same found set.

In a previous column, I provided the following steps to perform a find that adds the matching records to your current found set of records rather than replacing the current found set with a new one.

1. Perform a regular find for "Smith."
2. Enter Find mode.
3. Type "Smythe" in the Last Name field.
4. DO NOT click on Find. Instead go to the Requests menu and select "Expand Found Set."
5. FileMaker Pro performs the find and adds those records to the existing found set.

1. Open ScriptMaker and create a new script.
2. Add a Perform Find step to the script.
3. In the Script Step Options area, check Specify Find Requests.
4. Click on the New button to create the find request.
5. From the list of fields, select the one you want to search. For this example I'm using a field called "nameLast."
6. In the criteria box, type in your search term (I'm using "Smith"), and click on OK twice (figure 1).
7. Now add an Extend Found Set step to your script and repeat steps 3 through 5.
8. In the criteria box, type in your second search term (I'm using "Smythe"), and click on OK twice.

1. Open ScriptMaker and create a new script.
2. Add a Perform Find step to the script.
3. In the Script Step Options area, check Specify Find Requests.
4. Click on the New button to create the find request.
5. From the list of fields, select the one you want to search. For this example I'm using a field called "nameLast."
6. In the criteria box, type in your search term (once again, I'm using "Smith"), and click on OK.
7. Click on the New button to create a second find request.
8. From the list of fields, select the same field you chose in step 5.
9. In the criteria box, type in your search term (surprise! I'm using "Smythe"), and click on OK twice.
10. Save your script and run it.