Limiting modification access to a subset of records

Discussion created by jlan2205 on Sep 16, 2016
Latest reply on Sep 18, 2016 by jlan2205

I'm a fairly modest user of FM but have been using it for a number of years.


I need to set up a privilege set that limits the User to modifying those records "owned" by their group but still being able to add new records into their group. They can see all the records but only modify/add recrods in their group.


The groups are CLUBS so one thought is to have the Club owner log on with the Club name as their logon and use that to make the constraint in a privilege set.


Any simple suggestions welcome. As I said I'm a basic user.


The file in question can be seen at n35.fmphost.com and is called PFA Portal. The table in question is Players.




Jeff Langdon