6 Replies Latest reply on Aug 26, 2012 2:49 PM by schamblee

    Conditional Value list with a twist

    littledrew_1

      Title

      Conditional Value list with a twist

      Post

      Hello,

      Basic setup is: projects table and a people table. Projects have a value for specifying which group/team is working it. Based on that value, a conditional value list only show's people from that group/team. The tricky part, is that there is a special team whose members should always be available in addition to those on the regular teams. I thought I could edit the instance of the relationship that's used for selecting the teams, but you can't have condition 1 OR condition 2 in a realstionship! Any thoughts? I'm keeping the basic table structure as simple as possible, once I get this technique down it will be echoed in other parts of the database. Any ideas? 

       

      Thanks!

      -Andrew