10 Replies Latest reply on Jun 21, 2015 10:15 AM by director@charlesmoore.org

    Conditional Value Lists

    director@charlesmoore.org

      Title

      Conditional Value Lists

      Post

      Im working on a database whereby my boss <Shelton Keller> can generate proposal for clients.  I have a Company table that is related to a People table.  In a Proposal table I have set up fields where "teams" can be assembled, since not everyone at Shelton Keller or their client, Dell, is involved in each proposal.  However, as you can see, even thought I set up the relationships and value lists, for the Proposal fields <sales_team conditional> and <client_team_conditional>, the first works perfectly, generating a list only for Shelton Keller employees, but the second strangely gives me <Diana Keller> twice.  Any advice?  (In the screen shots for the Relationship tree, the green tables are occurrences of the ones above.)

       

      Screen_Shot_2015-06-21_at_10.29.53_AM.png