I need help trying to understand this: I have a large list of referees. Some of the referees are evaluated (assessments). Some of the referees take a running & written test every year. I need a table for both assessments and tests to relate to the referee (it's own table). Some of the referees are instructors. Some referees are assessors. These need to be pulled out with sorts. I also monitor new classes taught by one of my instructors (linked) and requested by an assignor (a referee that needs to be linked). I've tried all kinds of combinations of how to set up tables and relationships but I just can't seem to figure it out.