I have a application where users have access to hospital units. In the units you have hospital patients.
My problem is that the security settings are not enough for what i'm trying to do.
I want :
Person A to have access to UNIT A & UNIT B
Person B to have access to UNIT A
Person C to have access to UNIT B
I use dynamic rights for the tables.
I can give the table UNITS a field with access right. But i can only add one person.
Or have the table USERS to link to a UNIT but that they have only access to one UNIT.
normaly i would create a thirth table with two field : UNITS and USERS and create a list, for every unit i put the users who have access.
But i don't know how to setup the security parameters for this.
Does anybody know ?