set a group in form

[AccessWater]

I want to create a form that allows user to set up groups of projects. I plan to have two combo boxes. cmbA has group name, cmbB has all project names. User can choose a group name in cmbA and several projects in cmbB. That is, users create their own group of projects. I also want to save this group (both name and proejcts). Ideally, users are able to see what has been created and modify it. Note, users are not allow to go to the Tables.

Any suggestion is appreciated.
Thank you for your help.

 

[Mile-O]

Well, first you'll need a table for users and a table for projects. The last thing you need will be a junction table that contains at least two fields: one being the UserID and the other being the ProjectID. These two fields become the primary key of this table; the values are foreign key's to the respective tables.

On your form you can provide a form/subform combination that can have the user in the main form with his related projects in the subform. Or you can do it the other way round, listing projects in the main form listing users in the subform.

 

[Banana]

Search for Cascading Comboboxes and NotInList Event.

Edit= Realized I didn't read your post right first time. You will want to look at MultiSelect Listbox; that will be useful for projects.