Many to Many Relationship
I found an old tutorial on Many to Many relationships and thought I'd give it a try.
As expected, I can't get it to work. So I'm looking for help.
The database has three tables 9that are relevant)
Students - Relationships - Seminars
Students and Relationships are related by Student# and Students is allowed to add and delete records in Relationships
Relationships and Seminars are related by Seminar# and Seminars is allowed to add and delete records in Relationships... Standard Many to Many setup
I have a layout associated to Seminars, with a portal showing records from Students
The portal has three fields, Student# from Relationships, First and Last Name from Students.
Problem: I cannot see or select any of the fields in the portal?????