I want to limit the edit access at field level in the Filemaker database that I am working on. If I use a calculation in the privilege set to do this will this slow the speed of the database when generating reports.
You could use a script trigger on the field: OnObjectEnter
Get(AccountPrivilegeSetName) = "DataEntry"
Show Custom Dialog "You do not have edit capabilities on this field."
The concept is when they click into the field, it checks for the privilege set that you defined for edit access and exits the script if they can edit, leaving them in the field. If it doesn't match, you can do a dialogue box telling them they can't edit, then commit the record which immediately takes them out of the field.
I will assume that your reports runs are scripted processes. Scripts should be unaffected by Record Level Access in the permissions whcih affect only editing, not viewing.
If your report scripts require setting values on fields which have editing restricted, you can set the script itslef to run with Full Access Permissions in the script writing area via a checkbox at the bottom of the script definition window.
Thanks for the input
Retrieving data ...