Relationships/Multiselect

[jmcarroll7]

O.k. Now I have set up the 3rd Table. My structure is as follows:

Table 1 - Students
Student ID (PK)
Name, etc

Table 2 - Programs
Program Code (PK)
Program Names (each program belongs to one code)

Table 3 - Program Attendance
Contact ID (PK)
Staff Names
Location
Date
Programs (FK)
Contact Type
Time
Student ID (FK)
Notes

I have now set up a form based on Table 3. I have the Programs filed set up
as a list box w/ multi-select enabled, I also have the Students table set up
as a list box w/ multi-select enabled.

I have entered in 3 test Attendance forms. Now neither the students or the
programs I selected show up in the tables or reports.

Please let me know what I am NOW doing incorrectly.

Thank you!