# Separation of categories

**URL:** <https://community.glideapps.com/t/separation-of-categories/10038>\
**Category:** Ask for Help\
**Created:** [May 30, 2020, 11:56am UTC](https://community.glideapps.com/t/separation-of-categories/10038 "2020-05-30T11:56:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\
**Post date:** [May 30, 2020, 11:56am UTC](https://community.glideapps.com/t/separation-of-categories/10038/1 "2020-05-30T11:56:14Z")

</div>

Hello everyone. Tell me please.  
I have a few sheets:  
Country  
Cities  
Tours in these cities  
Tour Categories  
When we add a new tour we indicate: country, city, category and everything else.  
The question is, deduce the CATEGORY of tours in a certain city of a certain country, but in one category there can be several tours from other countries and cities! How to make a separation so that in a certain country and city there are categories of tours only from these countries and cities?  
That is, when visiting a certain country or city, we could find a tour by category in this country.

---

<div class="post-metadata">

**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:** [May 30, 2020, 12:00pm UTC](https://community.glideapps.com/t/separation-of-categories/10038/2 "2020-05-30T12:00:30Z")

</div>

Can you check if your solution can be found here?

> [@Relating a Category to a List of Episodes to a List of Videos with Details](https://community.glideapps.com/t/relating-a-category-to-a-list-of-episodes-to-a-list-of-videos-with-details/10011/13):
>
> Check out how I make three sheets here: Level 1: Category Level 2: Episodes Level 3: Videos In Level 1, I make a relation to the Episodes sheet. [image] In Level 2, I make a template joining the Category and the Episodes value, then use that column to make a relation to the Videos sheet. Make sure you also create a same template column in Level 3 to make the relation work. [image] [image]

---

<div class="post-metadata">

**Author:** ![NikolayPuh](https://avatars.discourse-cdn.com/v4/letter/n/e95f7d/32.png) [@NikolayPuh](https://community.glideapps.com/u/NikolayPuh)\
**Post date:** [May 30, 2020, 12:14pm UTC](https://community.glideapps.com/t/separation-of-categories/10038/3 "2020-05-30T12:14:41Z")

</div>

My category sheet does not intersect with countries and cities. Only with tours. That’s why I didn’t manage to connect the conclusion of the categories of tours in a particular city or country.

---

<div class="post-metadata">

**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:** [May 30, 2020, 12:16pm UTC](https://community.glideapps.com/t/separation-of-categories/10038/4 "2020-05-30T12:16:04Z")

</div>

Can you copy out a part of your data so I can work on it?
