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.