many to many with multi select

[Huber57]

Hello all:

I have a created a junction table that links my employee table with the
function table (function = 'legal', 'admin', 'finance', etc). [It is a
many-to-many as one person can have many functions and one function can have
many people.]

I would like to use a multi select list box to enter this data. I have read
other posts on the subject but can't determine if I need VBA or a sub-form or
some other mechanism to store this data in the table I have created.

Any thoughts, suggestions would be greatly appreciated!

 

[Douglas J. Steele]

The usual way to handle many-to-many is with a form and subform.

You can have the parent form bound to your employee table, and have the
subform bound to your junction table. On the subform, you can have a combo
box that has the function table as its row source, and bound to the function
id field in the junction table. This would mean that you could select from a
list of functions, and the appropriate id would be stored in the junction
table.

 

[Huber57]

Doug,

Thanks much. That worked perfectly.

The usual way to handle many-to-many is with a form and subform.

You can have the parent form bound to your employee table, and have the
subform bound to your junction table. On the subform, you can have a combo
box that has the function table as its row source, and bound to the function
id field in the junction table. This would mean that you could select from a
list of functions, and the appropriate id would be stored in the junction
table.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello all:

I have a created a junction table that links my employee table with the
function table (function = 'legal', 'admin', 'finance', etc). [It is a
many-to-many as one person can have many functions and one function can
have
many people.]

I would like to use a multi select list box to enter this data. I have
read
other posts on the subject but can't determine if I need VBA or a sub-form
or
some other mechanism to store this data in the table I have created.

Any thoughts, suggestions would be greatly appreciated!