This is my second post so, again, I apologize if this is blindingly obvious. I have checked the forums and watched the tutorial a number of times. I thought I got it, but perhaps what I want to do is not possible.
The application I am working on is commercial property management application using static security. A User table, which contains userids and passwords, will contain four types of entries (groups). The first group will be Tenants, which can only view and edit their own records. The second group will be Service, which can also only view and edit their own records. The third group will be Management which can view, edit, add, and delete Tenant and Service records, and can edit only their own Management record but not other Management records. The fourth group is Admin that can do everything.
Using Security Settings, I was able to restrict the groups to only edit their own records, but then, in the case of Management, I lost the ability for Management to view Tenant and Service records. Am I missing something or is that not possible. Thanks. Rob