I am having a problem establishing multi-level permissions for a project.
In DB1 I have:
ID
Partner
Company
Name
Moderator
What I need to do is have poeople be able to view/edit their own records (no problem, this works). The Moderator field contains user id's of moderators that can view/edit the records that are in their group. That is what I'm having the problem with.
Any direction would be appreciated. I haven't been able to make it work from the other threads in the forum.
BB