I have a simple report card database and when the teacher logs in, the choose their name from a drop down list in the current teacher field and find their students. How do I prevent them from possibly changing the current teacher in the found set and adding one of their students to another teacher in the drop down list. I am only a beginner and am worried about teachers inadvertently changing the teacher information. Is there a way to lock that field after the records are found? FM 6 (schools are using 6,5.5 and 5.0)

Hi, smith. Maybe you could have a calculated field on the layout that is available to them? That way, they can search in it but not change data. You could put the editable fields on a layout accessible to only you.

HTH,

Jerry

You can also restrict modification of the Teacher field via boolean calc in extended privileges so Teachers can not change the Teacher field unless it's theirs (in which case, why would they want (or need) to; or eliminate the real Teacher field and attach your popup to a global text instead (and use that in your Find). It wouldn't matter if they changed the field.

In vs. 7, you can disallow entry to Browse but allow Find (in Field Behavior). It's a nice addition, I think.

LaRetta