AnsweredAssumed Answered

Relationship to filter ids from value list

Question asked by deathrobot on Jun 4, 2014
Latest reply on Jun 6, 2014 by 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.

Outcomes