Many-to-Many Join Form

J

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.
 
B

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
 
J

JimS

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top