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
It won't work if Moderator field contains the list of IDs. You need to have a separate Users table and use User Group Permissions. You also might need create a separate view for Moderators use only.