But do they have access to the records involved? It's possible to set up security settings that control access to these records on a record by record basis so perhaps the settings in that privilege set permit access to some records but not others.
Try doing a show all records while on this layout and the file is open under the restricted level password and see if all records may be viewed or not.
Hi, Thanks for helping! Yes, they do have the ability to view all the records in this layout. I just tested it. But the script still is only editing in the first record.
When I run script debugger in that acct it doesn't "match all related records" as it does in the admin account. It only selects the current record... So when I have the next step "Go to record (next)" I get the 101 error message.
Again, when I run the same script under my account it runs perfectly. Finds all 3 related recrods and sets the fields appropriately.
You'll need to describe this in more detail. I'd like to see the actual relationship you've defined and the actual script used before making any guesses as to why this is happening.
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 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.