Showing Different Data Within the Same Relation
I've got two tables named WeekDays and Classrooms.
Weekdays is used as a value list where seven records store the seven weekdays' names and an associate code.
In Classrooms I have 5 fields, named WeekDay_1, WeekDay_2 and so on up to WeekDay_5 and would like to show, possibly, a different day (or non) in each of the five fields via relation between the two tables.
A relation, as far as I can see, will let me show up a single weekday and not any other one.
Is there a way to accomplish this?
I must admit I'm not properly in with variables and probably something may have to do with them.
Thank you in advance