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!!

[Suvrutt_Gurjar]

In general you could achieve the enumlist like behavior by making the column [Course ID] in the Enrollment table as Enumlist column with base type as reference.

However this will give rise to some other challenges that you please read in the following tips and tricks posts

Search - Google Cloud Community