Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unhappy Unanswered: Table design for multiple entries

    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?



  2. #2
    Join Date
    Apr 2002

    Check online help for the MultiSelect and Selected properties of a list box. You can cycle through the items in a listbox to get each selected item and put it in a separate record.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts