Jump to content
Sign in to follow this  

HELP on a calculated field to restrict users

Recommended Posts

School system using 5.0. 5.5 and 6.0 with a combination of Macs and PCs. Have a report card database where the teacher logs into their grade layout. Layouts are restricted by password. They do a FIND on the teacher field (a related field in the students database) to get their students. Then proceed to grade the students. We were having trouble with teachers being able to go back the click on the teacher field (which is a drop down value list of the teachers in their grade) and clicking another teacher while in browse mode, thus messing up the class lists. I added a second teacher field = to the related teacher field. This is the field they now do the FIND on. It is not modifiable, BUT a message comes up that says "unindexed records to search...processing field".... it solved the problem of the teachers not being able to modify, but it sure slows down the FIND. What did I do wrong....I was proud of myself for restricting the modification problem, but I don't think this was the correct solution. The users are people, some of whom have never seen FileMaker before. Can anyone please help - we are in the middle of grading. THANKS

Share this post

Link to post
Share on other sites

You're doing a find on an unstored calculated field equal to a related field. This will indeed take a while. Why not just attach a script to the button that tests

If [not Status(CurrentMode) and not IsEmpty(teacher)]

Show Custom Dialog ["A teacher has already been assigned to this record. Do you want to specify a different one?"]

If [status(CurrentMessageChoice) = 2] {"No" option}

Exit Script

End If

End If

Go to Field [Teacher]

This will pop up the message only if you are in Browse Mode and the teacher field is not empty. You'll need to remove the field from the Tab order, so that it can only be clicked to trigger the script.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    2 members have viewed this topic:
    tkakavros  sfpx 

Important Information

By using this site, you agree to our Terms of Use.