Jump to content
Sign in to follow this  
SES Tech

Limited Field Access

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

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  

×

Important Information

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