Help with limiting value list--possible table occurence issue?
Hello! A little help?
I have a table called "people" that has everyone involved with our organization on it that links in a many to many relationship to another table of "class registrations" like so. Table:People-->Table: Class Registrations-->Table: Classes.
Of the records in the people table, some are instructors for our classes. I have a field that can be checked if they are an instructor or left empty if they are not. I want to also link these instructors to the classes that they are signed up to teach (from Table:People to Table: Classes). You can see the problem there!
I created another table occurance of People, but I can't figure out to limit the records of this table occurance to only be instructors. Is there a way to do this?
Am I on the right track? Please help! Let me know if you need more info. Thank you!