I'm trying to set up a database in Access that encompasses a table with traiining courses and another that provides specific tasks from a competency framework. The issue is that any one course could provide training related to a number of competencies (one to many).
I've built the courses table to allow selection from the competency table using the lookup wizard. The question I have is: can I create a data entry form that will allow me to multiple select appropriate entries from the lookup field and have each of these selections appear as separate records in the courses table? Or is there a smart way of doinjg this that I'm missing?