Dowsey1977
Board Regular
- Joined
- Apr 6, 2004
- Messages
- 185
Hi,
I have a database which has currently got just 2 tables and 2 forms in it. 1 table/form has person data in it, the other table/form has information about access rights in it.
What I want is a subform that I can put on the person form to show what groups they belong to for access rights. There are 3 main groups for access rights witha bunch of more specific access levels within each group.
What I am asking for is advice on how to setup the database to be able to do that. Currently I have nothing that relates a person to a group, so really the setup is from scratch.
Any ideas?
I have a database which has currently got just 2 tables and 2 forms in it. 1 table/form has person data in it, the other table/form has information about access rights in it.
What I want is a subform that I can put on the person form to show what groups they belong to for access rights. There are 3 main groups for access rights witha bunch of more specific access levels within each group.
What I am asking for is advice on how to setup the database to be able to do that. Currently I have nothing that relates a person to a group, so really the setup is from scratch.
Any ideas?