force a check box list for a ref (creating what looks like an EnumList)

[jboudreau1970]

I'm trying to build a basic student database and I'm getting stuck in setting up a multi-select option when adding classes to students.

I have 3 tables, Students, Courses, and Enrollments.  The app works as shown below and as expected.

  Student Table

      Courses Table

Enrollment Table

The app works as follows:

What I'm trying to accomplish, is that when the 'Course Id' is selected a list of all available courses would be displayed with the ability to place a check box next to those that I want (creating multiple row in the Enrollment table). Ideally, the list would only contain those classes the student isn't currently enrolled, but that may be a different question.

NOTE: I'm keep this very basic to learn how to do this, eventually I'll be tracking start and end dates for each of these classes, so I need to have it in a separate table and not just use an EnumList.

Is this possible and are there any examples I could be pointed to?

Thanks in advance for your time and assistance on this matter!!