Select several items in combo box

[Daybreak]

Acces 97, no VB.  In the db I have an employee table and a table with 31 codes. In the data entry form I have a combo box that drops down & lists the 31 codes. The user may need to select up to 20 of these codes for each employee in the employee db.  How do I do this? Or am I going in the wrong direction on this one? I have never attempted anything like this before.  Need all the help I can get at this point.  Thank you!

 

[seaport]

You need to add another table.<br><br>Three tables are needed for your project<br>tblcodes - for the 31 codes<br>tblemployees<br>tblEmployeeCode - the link between tblcodes and tblemployees<br><br>The relationship is:<br>one code relate to many employees<br>one employee relates to many codes<br>

 

[elizabeth]

I'm not sure exactly what you're tyring to do but if you're not familiar with VB, here's a simpler approach that <i>might</i> work for your problem. Create 31 yes/No fields in your table, named by their codes, and use checkboxes to display and set them.