Table design question

[dcc15]

I have a "Users" table and in a new DB I am creating. I have two issues I an looking for suggestions/comments on. First I have various data entry forms that have or will have combo boxes for names of users that enter the data and I only what certain users available in the different forms/combo boxes, I am currently manually typing the users in each field property (Row Source).
Second I have several e-mail notification command buttons where the notification will be sent to various users, I am doing this by making "group" names in the Users table an in the email address I manually type all the addresses that will be in this "Group". I was thinking a better approach would to have a series of Yes/No check boxes to designate if the user is included in the combo box (look-up) or e-mail group (look-up), this sounds better to me but I'm fairly new to this level of DB design. Any suggestions/comment would be appreciated.
Thanks,
DCC

 

[KeithG]

You can use a query as your row source for the comboboxes. For the emails I would make an email group table and a Usergroup table. This way you can define your group info in the group table and then associate users to each group in the usergroup table. I would suggest reading up on normalization.

 

[dcc15]

Group Table?

If I were to make a group table, say 5 groups and I have a user that will be in 3 of these groups (a couple of users may be in all of the groups) how are you suggesting I associate the users to the groups if not check boxes, I'm not visualizing the association method. Of course I am looking for ease of implementation but my biggest long term concern is when a new user is added or one leaves or requires changes to their look-up boxes/notification group (removed from one/all, added to another) I don't want to have to change any queries or code. I did a quick test on querying a combo box and it seemed to do the job (check a user and name appears in the look-up, un check and user is no longer included. Thanks for your feedback.
DCC