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

    Showing Different Data Within the Same Relation

    GiovanniAndreani

      Title

      Showing Different Data Within the Same Relation

      Post

           Hello,

           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

           Giovanni