Relationships/List Box Multi-Select

J

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

Klatuu

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top