Re: Mass tie of items in one table to category in another ta
You might need to change the logic a bit. The link from Groups to MCL must use the primary key for Groups (in your case, ID). Once you have that, you can do the following:
Build the Groups form. Leave room at the bottom for a subform (this will be the users, based on MCL).
Using the Wizard, create the users subform. You'll need the UserID, the ID from the Groups table, Phone, and other contact details. Don't worry with the Name -- we'll tie that to UserID with a combo box. When you have all the fields you need, select the Datasheet option for display. This is usually the best way to display a subform. Save it as subUser, and close.
Now open subUser. You need to go to Design view, right-click the UserID field, and Convert to | ComboBox. Now select the Properties of the ComboBox. Click the builder button (...) in the RowSource property and you'll see the grid. This should just have the UserID field. In the adjacent (blank) field, create an expression : [FirstName] & " " & [LastName]. This will show Bugs Bunny (or whatever).
A different option would be [LastName] & ", " & [FirstName]. This will show Bunny, Bugs.
OK. Close, save when prompted, and change Columns (or ColumnCount) to 2. Change ColumnWidths to 0;3 (this hides the key field and shows the names).
Close the form and save.
Now the cool bit.
Open the Groups form in design view, and Restore so you can see the database container. Press the F11 key to bring the database container to the front. Click the subUser form icon, drag it onto the Groups form, and let go. Now right-click the subform, select properties, and check that the Parent (or Master) and Child fields are both ID. If not, edit them so they are. This synchronises the main and subforms.
Save, go to Datasheet view.
Now you have a series of Groups. To add new members, you click in the first field in the subform, and pick their names from the drop-down.
Denis