Relationships/List Box Multi-Select

[jmcarroll7]

O.k. Now I have set up the 3rd "Junction" 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 field 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!

 

[Klatuu]

We would need to see what the RowSource properties for the listboxes are to
be able to venture a guess.