It would help to see the script.
Exactly how is this check box set up and used?
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post a New Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.
Thanks for getting back to me.
Screen shot of Inspection Points and script follow.
And the script
Relationship if that helps.
The fourth line of your script is clearing the check box field shown in your screen shot:
That doesn't look right given that your next step is to perform a find on the same table.
That didn't seem to be the problem. I took the step out, ran the script twice and the last two check boxes cleared.
The Perform Find step is detailed below.
I just ran the script again. I'll try to explain how if performs. Notice on the check box field there is a machine type called Service Truck. If there were 10 Service Truck boxes checked when I run the script, it finds the first 9 and includes them on the Checksheet. Rather than finding all 10 and then clearing the last checked box so that the next time I run the script I only get 9 items. Not sure if that makes any difference but thought you should know.
Just to be clear. The clearing of the check boxes is for all machine types to which that Inspection Point applies, not just the Service Truck.
With that script step removed, there is nothing in your script is clearing any check box fields in the inspection point table. There is no step there that can change a value of a field in that table in any way.
So if a record comes up with that check box cleared, something else cleared it--perhaps this script is tripping a script trigger for another script that is changing that check box field.
OK, now at least I have confirmation there is nothing wrong with the primary script. Thanks, I'll look further.