4 Replies Latest reply on Apr 3, 2014 12:24 PM by GiovanniAndreani

    Showing Different Data Within the Same Relation



      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