# Join Relation Column **URL:** \ **Category:** Ask for Help\ **Created:** [September 2, 2020, 1:17pm UTC](https://community.glideapps.com/t/join-relation-column/15141 "2020-09-02T13:17:15Z")\ **Posts on this page:** 1\ **Showing post:** 6
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 3, 2020, 1:18pm UTC](https://community.glideapps.com/t/join-relation-column/15141/6 "2020-09-03T13:18:49Z")
So each relation is to the same sheet? I was understanding it as 2 similar relations to separate sheets, but with the same column used for each relation. Anyhow, what I would do is create columns in the sheet used for your list. These could either be Single Value columns or Relation/Lookup columns that will bring in your filter criteria into your listing sheet. Then create IF/THEN columns then check each filter criteria. Finally create a final IF THEN column then checks if all other conditions are true and returns a final true or false value that you can use to filter your list. In the end you’ll only need a single relation, but the true false values in the related listing sheet will determine how you filter that list, based on your filter selections. > [@Choice component: display "all" when no choice?](https://community.glideapps.com/t/choice-component-display-all-when-no-choice/15176/7): > > @AyS_0908 What if you used the same approach as your “Dynamic Group-By”, and brought in all the choices into your content sheet. Then through various If Then columns, you could set true or false if the filter condition is met. Then have a final If Then that checks the individual If Then columns and returns True if all other conditions are met. Else it returns False. You should only need one list that’s filtered on the final If Then column. > [@How to make an app like Zillow with advanced filtering](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517): > > Hey everyone! I’m starting a no code tutorial site called No Code MBA, initially focused on Glide, giving step by step instructions on how to build apps without code. The first tutorial I created is a real estate app like Zillow using Glide. The tutorial has 8 lessons (about 2.5 hours of content). You can access the tutorial for free at [nocode.mba](https://www.nocode.mba/courses/zillow) The tutorial includes: Advanced filtering to view homes User onboarding A “favorites” tab for homes If you are interested in this tutorial and yo… --- _[View the full topic](https://community.glideapps.com/t/join-relation-column/15141)._