Many-to-Many Join Form

[JimS]

I have a vendor table joined to another skills table with a many-to-many
structure. I normalized it, so I've got a one-to-many join to a
cross-reference table, with a many-to-one join to the list of all possible
skills...

I want to present an update-able form that allows the user to select the
vendor record, then update the skills associated with that vendor, all on the
same main form.

Incidentally, each vendor has multiple addresses, so I want to present a
form where the user can scroll through and update either child table, at his
or her discretion.

 

[Barry Gilbert]

When I've done this sort of thing in the past, I use a main form with two
subforms. In your case, the main form would be a continuous form bound to the
vendors table. This allows the user to scroll through the list of vendors and
change field values. In the form's footer, put two subforms, side-by-side.
The subform on the right contains a list of skills assigned to the selected
vendor. The subform on the right contains a list of skills not assigned to
the vendor. Between the subforms are two buttons to add or remove skills.
Beneath each button, you'll need code to insert or delete a records in your
association table.

This takes a bit or work, but I find that it presents a very intuitive UI
for most users.

Barry

 

[JimS]

Intruiging Idea. Although it doesn't address the way I wanted to do it, I
like it.
Thanx!