6 Replies Latest reply on Aug 22, 2016 4:29 AM by beverly

    Creating an "OR" relationship


      I can't find an answer to this using the search so I apologize if this has already been discussed.

      I'm trying to set up a relationship to find either a "Teacher" or a "Supervisor".

      In my Employee table I have an EmployeeStatus checkbox set up which has "Student", "Teacher", "Supervisor" and "Manager"

      In my Report table I would like to have a portal which only shows Employees which are either a "Teacher" or "Supervisor"

      The Report Table also includes to global fields:

      g_Teacher = "Teacher"

      g_Supervisor = "Supervisor"

      When I try to do this in relationships it shows:

      Report::g_Teacher = Employee::EmployeeStatus


      Report::g_Supervisor = Employee::EmployeeStatus


      Which doesn't work, I get no values.


      What do I need to do to make this work?