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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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