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!

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
http://I.Am/DougSteele
(no e-mails, please!)


"Huber57" <Huber57@discussions.microsoft.com> wrote in message 
news:47324B5F-D9C6-4680-96A7-82CFC527A6A2@microsoft.com...
> 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!
>
> 

Doug,

Thanks much.  That worked perfectly.  

"Douglas J. Steele" wrote:

> 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
> http://I.Am/DougSteele
> (no e-mails, please!)
> 
> 
> "Huber57" <Huber57@discussions.microsoft.com> wrote in message 
> news:47324B5F-D9C6-4680-96A7-82CFC527A6A2@microsoft.com...
> > 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!
> >
> > 
> 
> 
>