4 Replies Latest reply on Jun 6, 2014 4:27 PM by deathrobot

    Relationship to filter ids from value list

    deathrobot

      Title

      Relationship to filter ids from value list

      Post

           I have the following tables:

           PROJECTS ---> TEAM <--- People
                   id              id_Projects       id
                                     id_People

           On the Projects table layout is a portal showing team members (Team::id_People). When clicking on this field, there is a drop-down list which shows all the id's in the People table. The only problem is that I can add the same id to the Project multiple times. I'd like to alter the value list so it doesn't show people already related to that project.

           Is there a relationship I can set up to create a value list of all People::id's EXCEPT those that are related to the current Project::id via the Team join table?

           Thanks,
           Michael

           that it shows all the people id's EXCEPT for those already related to the Project via the Team table.