Your script could be modified to work like this:
Enter Find Mode [ ]
Set Field [ Testing Dates::date_1_mo; Get ( CurrentDate ) & "..." & Get ( CurrentDate )+30 ]
Set Field [ Testing Dates::date_2_mo; Get ( CurrentDate ) & "..." & Get ( CurrentDate )+30 ]
Set Field [ Testing Dates::date_3_mo; Get ( CurrentDate ) & "..." & Get ( CurrentDate )+30 ]
Set Field [ Testing Dates::date_6_mo; Get ( CurrentDate ) & "..." & Get ( CurrentDate )+30 ]
Perform Find [ ]
Putting each criterion in a different Request produces the Or logic you want.
However, all those dedicated fields suggest a design change may simplify your life all along the way. You might consider setting up a related table where each of the above fields is replaced by a single record in the related table.
The script tip worked great. Thanks for the help.
When it comes to Filemaker and databases, I am Toonces the Driving cat. "See, I told you he could drive! Just not very well!".
I am both intriqued and confused by the table layout suggestion. Right now I have two tables: the first, has the product, cat. no., manufacture date, expiry date and check boxes for each future test required. The second table has all the test dates (calculated on the manufacture date if the box for the test is checked) with the two tables linked by an ID number. Seemed logical to me, but, then again, I'm a noob.
Can you explain a little bit more?
I have only a very incomplete picture of your database structure and function...
"Testing Dates" is the related table of testing dates? It sounds like you have one record (or no record) in testing dates for each record you created in your first table.
If so, just keep a single testing date field in your Testing Dates table and display a group of related testing date records in a portal. You can create a script that creates the whole group of testing date records each time your user clicks the check box for test.
Yes, I kinda looked the the portal thing while flattening my face against a wall on the scripting problem. The whole portal thing is a mist shrouded concept for me, but I'll give it a shot.
Once again, thanks for your time and help.
A portal is an extremely useful tool in filemaker. Read up on it in filemaker help and feel free to ask questions here if you can't figure something out.