Matrix input form

[mlswyo]

I have two access 2010 tables; one with a list of employees, the other a list of training topics. I've related the two through a junction table whose primary key is a composite key from each of the two tables. My goal is to quickly assign individual employees to training topics. Not all employees will be assigned to all topics but probably will be assigned to a number of them.

What I would like is a matrix with the topics across the top at the head of each column and the employees down the left as the head of each row. Then simply marking the junction of a row and column, the employee would have that topic as a required training. these requirement I assume I could store in the junction table.

Can someone tell me how to do this or tell my a quicker way or tell me I'm wasting my time.

thanks for your help.

mlswyo

 

[pbaldy]

I can't think offhand of a way to do the matrix. You could probably get the look with a crosstab query, but it would be read-only. I'd probably have a form with a multiselect listbox for training items and a combo box to choose employee, and use this technique to add records to the junction table:

http://www.baldyweb.com/MultiselectAppend.htm