AnsweredAssumed Answered

Help with limiting value list--possible table occurence issue?

Question asked by iwrc on Apr 14, 2011
Latest reply on Apr 21, 2011 by iwrc

Title

Help with limiting value list--possible table occurence issue?

Post

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!

Kim

Outcomes