# Can't work out nested relationships that share multiple entries **URL:** \ **Category:** Ask for Help\ **Created:** [August 27, 2020, 2:30am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785 "2020-08-27T02:30:15Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Sam\_Marchant](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam_marchant/32/838_2.png) [@Sam\_Marchant](https://community.glideapps.com/u/Sam_Marchant)\ **Post date:** [August 27, 2020, 2:30am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/1 "2020-08-27T02:30:15Z")
Bit of background: I’m attempting to build a staff list that needs to be divide up into Productions, departments, Crew using inline lists. My issue is that I can get Productions and departments to show nested correctly (using relationships), however I can’t get the Crew to come through on the department level correctly. Currently Crew are showing up in multiple productions as they all belong to departments that share the same name instead of showing up in a single department nested under a production. ie. What is supposed to happen: ``` Production 1: | ____ Department (modeling) | ____ Crew (James) | ____ Department (Animation) | ____ Crew (Adam) Production 2: | ____ Department (modeling) | ____ Crew (Paul) | ____ Department (Animation) | ____ Crew (Chris) What is happening: Production 1: | ____ Department (modeling) | ____ Crew (James) | ____ Crew (Paul) | ____ Department (Animation) | ____ Crew (Adam) | ____ Crew (Chris) Production 2: | ____ Department (modeling) | ____ Crew (Paul) | ____ Crew (James) | ____ Department (Animation) | ____ Crew (Chris) | ____ Crew (Adam) ``` I need to be able to divide the crew into departments that share the same names but belong to different productions. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 27, 2020, 2:35am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/2 "2020-08-27T02:35:34Z")
You must have a full unique condition/relation for it, in this case for James it should be a combination of production - type of department - crew. I.e a template column of Production 1 - Department modeling - Crew. ---
**Author:** ![Sam\_Marchant](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam_marchant/32/838_2.png) [@Sam\_Marchant](https://community.glideapps.com/u/Sam_Marchant)\ **Post date:** [August 27, 2020, 5:36am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/3 "2020-08-27T05:36:00Z")
Thanks for the feedback ThinhDinh but I’m not super sure I understand. Currently my sheets are set up like so: Tab (Staff): Contains the Crew names, department and production (and other info like phone numbers etc) Tab (Productions): Contains the list of productions (only listing each once, not per department /crew) Tab (Departments): Contains the list of departments (only listing each department once, not per production / crew) I have the list of productions from Tab (Productions) being referenced, then a relation for the Tab (Production) --\> Tab (Departments) but then pulling in the crew via relation, no matter what I do it adds multiple entries to the departments. I think I understand what you mean about having a unique item for each but haven’t had any luck getting it working… Example sheet: [https://docs.google.com/spreadsheets/d/1g--G9snBz7m2mkFyX5omRwUALK51kEP2F-Jf4UBKQd4/edit#gid=0](https://docs.google.com/spreadsheets/d/1g--G9snBz7m2mkFyX5omRwUALK51kEP2F-Jf4UBKQd4/edit#gid=0) I’m sure I’m doing something wrong that is actually super simple. I’m just not seeing it… ---
**Author:** ![Sam\_Marchant](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam_marchant/32/838_2.png) [@Sam\_Marchant](https://community.glideapps.com/u/Sam_Marchant)\ **Post date:** [August 27, 2020, 7:33am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/4 "2020-08-27T07:33:02Z")
Figured it out. Thanks, Sam ---
**Author:** ![Alexandra\_Groszek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandra_groszek/32/32649_2.png) [@Alexandra\_Groszek](https://community.glideapps.com/u/Alexandra_Groszek)\ **Post date:** [April 2, 2022, 8:29am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/5 "2022-04-02T08:29:49Z")
Hi I have a similar problem - I have a choice dropdown component allowing multiple entries into a OCHA Cluster column in a sheet. The column is updating fine when multiple items are selected via the choice dropdown. The Name column in this sheet is connected to an NGO column in a sheet as a relation (see image attached), however this NGO column is not updating when there are multiple entries in the source OCHA Cluster column. How to solve this? This is for an NGO emergency coordination resource - help would be much appreciated! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/49c9357af72dd153f65839d99778ea8295f02853.png) ---
**Author:** ![Alexandra\_Groszek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandra_groszek/32/32649_2.png) [@Alexandra\_Groszek](https://community.glideapps.com/u/Alexandra_Groszek)\ **Post date:** [April 2, 2022, 8:34am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/6 "2022-04-02T08:34:26Z")
The same happens if I enter multiple items manually in the source column, spearated by commas - perhaps there is a way these have to be entered for the relation to recognise them? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 2, 2022, 8:46am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/7 "2022-04-02T08:46:48Z")
> [@Alexandra\_Groszek](#): > > I have a choice dropdown component allowing multiple entries into a OCHA Cluster column in a sheet. To create a relation from this, you would first need to create a split text column from the joined list, and then use that for the relation. ---
**Author:** ![Alexandra\_Groszek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandra_groszek/32/32649_2.png) [@Alexandra\_Groszek](https://community.glideapps.com/u/Alexandra_Groszek)\ **Post date:** [April 4, 2022, 1:04pm UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/8 "2022-04-04T13:04:07Z")
Ah OK I just saw this I didn’t get an email! Let me try this thank you! ---
**Author:** ![Alexandra\_Groszek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandra_groszek/32/32649_2.png) [@Alexandra\_Groszek](https://community.glideapps.com/u/Alexandra_Groszek)\ **Post date:** [April 5, 2022, 11:28am UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/9 "2022-04-05T11:28:22Z")
Split text worked, thanks so much for your help! ---
**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:49pm UTC](https://community.glideapps.com/t/cant-work-out-nested-relationships-that-share-multiple-entries/14785/10 "2024-01-17T16:49:35Z")