1 of 1 people found this helpful
You seem to have the basic idea.
You can set up a table of Clubs with a field that lists all account names for users that are a member of that club.
Logging in triggers a script that looks up the club to which a user is a member and loads the Club ID into a global field or variable.
Any new record can auto-enter that Club ID from the global.
You can then set up an expression that compares the auto-entered club ID with the current user's club ID (the value in the global) to determine whether or not the user has edit rights for the current record.
Great. I only intend to have one user for each club, so I should be able to have them log on using the Club name as their account name.
I'm not an advanced user of privilege sets. (to tell you the truth I've hardly used them at all!). How do i say ... if you log as as <<Club Name>> you can only modify/add records for that Club?
Open Manage Security.
Set up the privilege set you will use with these accounts.
In the tmenu for "Records", select "Custom Privileges". Select the table for which you want to set these limitations and then select "Limited"
Then enter an expression such as:
AccountNameField = Get ( accountName )
Where I have used "accountnamefield" refer to a field in your table that auto enters the creator account name. If you already have data in your table before you add this field, you will need to also update the existing records to show the correct account name.
This will then limit edit privileges to just those created by the current user's account.
Thanks a lot. You've been a great help. I think Ive got it now.