New user alert...

This is my first FM database and any help would be greatly appreciated.  I want a set of user with a certain privilege set to be able to view and edit the records for all members of staff in their department.

I thought of doing something like this in a script

• Find record of user that has logged in
• Find department code from the logged in user record and set as the value as a variable
• Set the custom record privilege limited... view when department code = variable

Is this a sensible approach?  How do I go about scripting the first 2 points?

Thanks in advance.

Ben

Basically, no.  You can't do it like this.

The custom record privilege is applied before any script is run so it seems you can't generate a variable via script for use in limiting the record access.

I have done it by modifying the found set of records with a script and not allowing the user to modify the found set.