1 Reply Latest reply on Feb 14, 2012 3:29 PM by philmodjunk

    Record access, approve only what you may.



      Record access, approve only what you may.


      I have a database in FM11, to manage events, where events have tables and tables of event managers. Each manager has two technicians who list events, then managers have to approve the event for your area. What I want to do so is the manager sees only the event that belongs to him to decide whether to approve or not.

      Any idea is welcome...

        • 1. Re: Record access, approve only what you may.

          You'll need relationships that link events to managers. Since a manager can be responsible for many events this appearsto be this relationship:


          If an event can have many managers, a different relationship using a join table is needed.

          The above relationship can be implemented with:

          Manager::__pk_ManagerID = Events::_fk_ManagerID

          With this relationship, a portal to events on the Manager layout will only list the events assigned to that manager. Other methods using finds or go to related records can be used as can settings in Manage | Security that prevent a manager from editing (or even keep them from viewing) records not assigned to them.