# Help- Eliminate a option

**URL:** <https://community.glideapps.com/t/help-eliminate-a-option/29091>\
**Category:** Ask for Help\
**Created:** [July 14, 2021, 4:32pm UTC](https://community.glideapps.com/t/help-eliminate-a-option/29091 "2021-07-14T16:32:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [July 14, 2021, 4:32pm UTC](https://community.glideapps.com/t/help-eliminate-a-option/29091/1 "2021-07-14T16:32:49Z")

</div>

Hi Gliders,

need your help!

I have a users sheet, where users create their profile and select their role. I want a way to stop another using taking captain role, once its already taken for that particular team.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6d221301591c4de0b4b4f8d3b9b45a7058d2ce5.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2db629e3ff3f4b3b3462abfa0dd5fa60bbeaea15.png)  
(captain role image should not be visible if its taken)

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [July 14, 2021, 4:40pm UTC](https://community.glideapps.com/t/help-eliminate-a-option/29091/2 "2021-07-14T16:40:46Z")

</div>

Hola @Amal

I would create a multiple relation from the team to the team. Then create a joined list column from that relation.

Lastly I’d filter that list of roles by role is not included in joined list.

I hope this helps.

---

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [July 15, 2021, 4:21am UTC](https://community.glideapps.com/t/help-eliminate-a-option/29091/3 "2021-07-15T04:21:36Z")

</div>

thank you! if your suggestion and some extra config was able to achieve, what i was looking for finally!!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/help-eliminate-a-option/29091/4 "2024-01-17T16:51:29Z")

</div>