Since you have 5 different fields, you'd need 5 different relationships to 5 different occurrences of your WeekDays classroom so that each WeekDay field can be a match field to a different occurrence of WeekDays.
But this does not seem like a very practical way to set up your relationships.
Won't your 5 fields always need to show the text Monday for WeekDay_1, Tuesday for WeekDay_2 and so forth?
In any case, you could replace your 5 fields with one related table in this relationship:
Classrooms::__pkClassroomID = Days::_fkClassroomID
WeekDays::__pkWeekDayID = Days::_fkWeekDayID
Then you can create 5 records in Days linked to Classrooms and select your ID for the needed week day in each of these 5 related records. 5 one row portals can be placed on your layout to take the place of the 5 week day fields.
Thank you, I'll give it a try, certainly better than the five relationships.
Could you tell what those "fk" and "pk" prefixes stand for (are they for 'portal key' and 'field key)?'
Primary key and Foreign key. I left out a link that I usually include when I post this type of info:
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained