# Filtering by one table, showing joined data from another
**URL:** https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342
**Category:** Ask for Help
**Created:** [February 23, 2023, 4:15am UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342 "2023-02-23T04:15:37Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@jb229229](https://community.glideapps.com/u/jb229229)
#### Post date: [February 23, 2023, 4:15am UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/1 "2023-02-23T04:15:37Z")
Hello! New to Glide and excited to engage with the community and hopefully eventually give back some š
I have two primary tables:
1. users (name, email, etc.)
2. products (name, description, etc.)
Iāve connected them with a `user_product` table which creates a row each time a user makes an election on a product (e.g., user A said āyesā to product A).
In the screen Iām building, Iām essentially trying to show all of user Aās āyesā election products on a screen, and all the underlying data from the product table.
Iāve tried two routes:
If I start building this screen from the products table, I canāt seem to filter with the user\_product table, and it doesnāt feel right to bring user dimensions into that product table.
If I start with the user\_product table, I can effectively filter for āyesā only products, but the columns Iād like from the product table arenāt available to use. Perhaps I need to bring all the relevant product fields over via relation columns into the user\_product table for this to work? Just feels redundant if the association is already thereā¦
What am I missing??
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 23, 2023, 4:34am UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/2 "2023-02-23T04:34:38Z")
I think I have an answer for you, but Iād like to be able to better visualise what you have first.
Would you mind adding a screen shot of each table?
---
### Author:  [@jb229229](https://community.glideapps.com/u/jb229229)
#### Post date: [February 23, 2023, 2:03pm UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/4 "2023-02-23T14:03:11Z")
User table (pretty basic):
---
### Author:  [@jb229229](https://community.glideapps.com/u/jb229229)
#### Post date: [February 23, 2023, 2:03pm UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/5 "2023-02-23T14:03:43Z")
user\_product table (where the user makes an election about a product):
---
### Author:  [@jb229229](https://community.glideapps.com/u/jb229229)
#### Post date: [February 23, 2023, 2:05pm UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/6 "2023-02-23T14:05:48Z")
product table (also pretty basic):
---
### Author:  [@jb229229](https://community.glideapps.com/u/jb229229)
#### Post date: [February 23, 2023, 2:07pm UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/7 "2023-02-23T14:07:31Z")
@Darren_Murphy thanks, see above! So Iām trying to get a page of product columns that I can filter based on which products the user (josh) accepted (election column).
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 23, 2023, 2:20pm UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/8 "2023-02-23T14:20:40Z")
yep, no problem.
Firstly, I have a couple of suggestions.
- Add a RowD column to your Users table, and use that as a UserID
- Add a RowID column to your Products table, and use that as a ProductID
- In your UserProduct table, instead of storing User Name & Product Name, store the respective ID values for each.
Taking the above approach will make for a much more robust solution, which wont be subject to breakage if/when User or Product names are changed.
Now, to the challenge at hand:
> [@jb229229](#):
>
> If I start with the user\_product table, I can effectively filter for āyesā only products, but the columns Iād like from the product table arenāt available to use. Perhaps I need to bring all the relevant product fields over via relation columns into the user\_product table for this to work? Just feels redundant if the association is already thereā¦
I think what you are looking for here is something we refer to as Inline Lookups, which unfortunately arenāt available in Glide (a long standing feature request, but thatās a separate story).
So yes, essentially what you need to do is create relations to link the tables - as I can see youāve already started doing - and then use lookup columns to bring in any related data that you need.
This might feel like data redundancy, but it isnāt really. These are computed columns that cost nothing - there still remains a single source of truth in each of the respective tables.
> [@jb229229](#):
>
> So Iām trying to get a page of product columns that I can filter based on which products the user (josh) accepted (election column).
Many different ways you can approach this. Can we assume that the user (Josh) will be the currently signed in user, or could it be any user that has been selected from a list of users?
Yes, I know I havenāt given you a direct answer yet, but Iām working my way to it š
---
### Author:  [@jb229229](https://community.glideapps.com/u/jb229229)
#### Post date: [February 24, 2023, 2:32am UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/9 "2023-02-24T02:32:43Z")
Yes fair to assume Josh will be signed in user, good question!
---
### Author:  [@jb229229](https://community.glideapps.com/u/jb229229)
#### Post date: [February 25, 2023, 10:25pm UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/10 "2023-02-25T22:25:46Z")
@Darren_Murphy I think it actually works well when I put more product columns into the user\_product table like you suggested. Then I can base the whole page/tab on that user\_product table and can thus leverage the filtering columns I need. I think Iām good?! Thanks again. Iām sure Iāll have another question in a matter of hours here š
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 26, 2023, 4:42am UTC](https://community.glideapps.com/t/filtering-by-one-table-showing-joined-data-from-another/58342/11 "2023-02-26T04:42:56Z")
oh, Iām sorry - I forgot that I owed you a reply.
Things can get a bit lost sometimesā¦
> [@jb229229](#):
>
> Then I can base the whole page/tab on that user\_product table and can thus leverage the filtering columns I need. I think Iām good?!
yep, that should be fine