Security Settings Help
Hello all I'm working on a project where personnel can submit leave requests through filemaker pro and the leave requests are sorted and stored in a data base which will later relate to a staffing database. So far everything is working great! I have two layouts for my "Leave Database" (LD), one is called "Leave form" and the other is called "Master Sheet".
What is supposed to happen is personnel will access the LD and submit a record (their leave request) through the "leave form" layout. The "Master Sheet" layout lists all the leaves by start date and the time stamp and allows officers to come in and check whether to approve leave on the list or not. If an officer approves the leave it is marked approved on the "Master sheet".
Basically the "Master Sheet" is a roster that everyone can view but only select people can modify (such as changing hours of leave or choosing to check approved) and the "leave form" is modifiable by everyone so they are able to submit leave requests.
The problem is that I need a very specific set of access privileges for the "leave form". Ideally those using the sheet would either be an administrator or a guest. Guests would be able to view everything and create new records but NOT delete, edit or change records that have already been entered, including records entered previously by them. We do not want to assign everyone a user id and password (but if necessary we will).
I’ve gone to security settings and attempted to modify the privileges. I’ve even played around with Boolean formulas but the problem I keep running into is the guest profile (or any other profile I create that I put permissions on) isn't able to create any new records at all. I need guests to be able to create new records for this to work but not change them after they've entered information in the fields.
Thanks for any help you can give.