AnsweredAssumed Answered

Showing Different Data Within the Same Relation

Question asked by GiovanniAndreani on Apr 2, 2014
Latest reply on Apr 3, 2014 by GiovanniAndreani


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