I am new here, and to MS Access as well.
I am using MS Access 2007, but saving everything so that it is compatible with 2000-2003 format (.mdb)
What I want to do seems simple enough, however I am finding it very difficult to use Forms. (Maybe there is more into this
than forms, but I guess I will find out sooner or later.)
Here's what I want to do:
I am trying to create a simple database to keep track of *Users* who have access to certain websites in a Content Management
The users are managed by adding them into *Groups*.
And the Groups are added to each *Website* to grant the required access to the Users.
* One or More users may belong to One or More Groups
* One or More Groups may have 0 or more users
* One or More websites may belong to One or More Groups
* One or More Websites may have 0 or more Groups
User01 is in Grp_Admin, Grp_Editor, Grp_Publishers
User02 is in Grp_Admin, Grp_Editors
User03 is in Grp_Publishers
And we have the following websites:
To give access to Users, the desired groups are added to the corresponding Website.
Website_01 (add: Grp_Admin, Grp_Editors)
Website_02 (add: Grp_Admin, Grp_Publishers)
As you can see, I have TWO Many-to-Many relationships between 3 tables.
So I have the following design: (Please correct me if I'm wrong)
(FK-from "Groups") GroupID
(FK-from "Websites") SiteID
If the above is correct,
All I simple want to be able to do is the following:
1) Have an FORM to INPUT
(A) I want to be able to Enter a new User, and allocate that user to a Group (either an existing or a new Group)
(B) I want to be able to Enter a new Group, and allocate Users to this group (either existing users or new users)
2) Have a display area for records.
I want to
(A) search for a group, and list all the Users that belong to that group.
(B) search for a group, and list all the Websites that belong to that group.
(C) search for a user, and list all the Groups that this user belongs to
(D) search for a user, and list all the Websites that this user, in tern, has access to. [This might not be needed.. not sure
I just cant seem to understand how the FORMS work in Access!
I have a bit of a programming back ground, and I can see how I can program such a thing using Objects etc... and how I can
create a form that a user can input which will populate a DataBase Table etc.. and how I could do a query and retrieve
whatever I want, and however I want.
but.. I thought MS Access might have all these type of simple things already inbuilt..
And in fact I think it does!
I just cant seem to figure out how to use them!
So,.. any help would be great?!!
I have attached what I have done so far, but if anybody could point me in the right direction, it would be much
Thanks a lot!