Update table with multi-select list box

[thart21]

I have a form which I will use to enter new documents that employees need to review. For each new document, only certain employee are required to read it. I have set up a list box with all employees and want to mult-select all of the appropriate names for each new document. I then want the table to be updated with the new info. I can get it to work with a combo box, but don't want to enter a new record for each employee for the same document. I have been unable to find a solution in here or in the MS Knowledge base.

Any help would be appreciated!

Toni

 

[llkhoutx]

One solution, requiring minimal overhead, is to create a junction table with employeeid and documentid fields indicating what documents each employee is to review.

 

[servoss]

Couldn't you...

make the field bound to the combo/list box a memo field and then concatenate all of the reviewer names together (separated by spaces)?

or, create a field for each reviewer and make it a yes/no field, then update the yes/no for each reviewer based on if it was selected or not?

niether of these would work if there are a large number of reviewers, probably.

just a thought or two.