At our school, I'm writing a report card program. We have 4 marking periods and want to limit access to one period at a time - controled by a priviledge set. It it I've made the fields that I don't want modified by class them as No Access. [The value are entered with a drop down value list] The layout uses the Student table, but references the Grade records associated with each student. I've given full access to Student (and all other tables) but limited it in grades (modifiable for the ones I want - no access for the ones I don't). I get the message "This operation cannot be performed because one or more required related records are not available and cannot be created". It works fine in Full Access.

Any suggestions would be very welcome. Thank you

You could allow access based on a Boolean condition of dates, rather than simply "no access."

Yes, that would be perfect. How?

File | Accounts & Privileges | user | Edit | Edit Privilege Set | Records | Custom Privileges | table | Edit | limited ... | Records can be edited when

Let ( [ td = Get ( CurrentDate ) ] ;

td >= (your_first_allowable_entry_date) and

td <= (your_last_allowable_entry_date)

)

HTH.

Thanks, but I have to restrict 3 out of 4 fields (GradeMath1, GradeMath2 . . . GradeMathFinal) for each subject plus sub-bullets, for each quarter. So I have to do it field by field.

OK, then do this:

File | Accounts & Privileges | user | Edit | Edit Privilege Set | Records | Custom Privileges | table | Edit | Field Access | Limited | pick 3 of 4 fields to have No Access

Come to think of it now, it would be helpful to have a Boolean entry condition for fields, like we do for records. Are you reading this, FMI?