# Accessing Related Table Data in Big Tables
**URL:** https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273
**Category:** Ask for Help
**Created:** [June 28, 2023, 6:18pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273 "2023-06-28T18:18:24Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@mondrew](https://community.glideapps.com/u/mondrew)
#### Post date: [June 28, 2023, 6:18pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/1 "2023-06-28T18:18:24Z")
Morning Gliders!
I just started using Big Tables for some of my data and I can’t seem to figure out how to show data in the layout from a related table.
Here’s the scenario: I have a table called Months Stats and in that table it relates to another table’s unique ID called Months. The relation works, but when I’m in the interface, I can’t select any of the fields from Months to add to the layout. Am I missing something there?
Grateful for your help,
Andrew
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 28, 2023, 6:19pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/2 "2023-06-28T18:19:44Z")
Is it a single or a multiple relation?
Which type of component are you wanting to use it in?
---
### Author:  [@mondrew](https://community.glideapps.com/u/mondrew)
#### Post date: [June 28, 2023, 6:23pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/3 "2023-06-28T18:23:03Z")
Hey Darren,
> [@Darren\_Murphy](#):
>
> Is it a single or a multiple relation?
This instance is a single relation.
> [@Darren\_Murphy](#):
>
> Which type of component are you wanting to use it in?
I’m just trying to use the text as a label in a chart.
Drew
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 28, 2023, 6:24pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/4 "2023-06-28T18:24:38Z")
Okay. The relation just establishes a link between the two tables. You can use Lookup columns to bring in any values that you need, through the relation.
---
### Author:  [@mondrew](https://community.glideapps.com/u/mondrew)
#### Post date: [June 28, 2023, 6:27pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/5 "2023-06-28T18:27:05Z")
Great!
> [@Darren\_Murphy](#):
>
> You can use Lookup columns to bring in any values that you need, through the relation.
For some reason, it shows the lookup as an array and then I don’t see that in the interface.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 28, 2023, 6:31pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/6 "2023-06-28T18:31:08Z")
oh, you have a Query there, not a relation.
Query columns are a bit different - to get the value that you need you will need to use a Single Value column.
---
### Author:  [@mondrew](https://community.glideapps.com/u/mondrew)
#### Post date: [June 28, 2023, 7:32pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/7 "2023-06-28T19:32:06Z")
Thanks, Darren.
> [@Darren\_Murphy](#):
>
> oh, you have a Query there, not a relation.
I did have a relation column, but the result was the same. 🙂
I’ll try the Single Value column.
Thank you!
Drew
---
### Author:  [@mondrew](https://community.glideapps.com/u/mondrew)
#### Post date: [June 29, 2023, 8:27am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/8 "2023-06-29T08:27:57Z")
I added a Single Value Column, and still no luck…
it doesn’t show up as an available option:
Any ideas?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 29, 2023, 9:21am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/9 "2023-06-29T09:21:31Z")
Interesting. I don’t see any reason why you shouldn’t be able to use that.
Possibly an undocumented limitation of Big Tables with Charts, but I would’t have thought so.
Looks like I still have access to your team - do you mind if I have a quick look?
You’ll just need to direct me to the correct App and screen to look at.
---
### Author:  [@mondrew](https://community.glideapps.com/u/mondrew)
#### Post date: [June 29, 2023, 9:43am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/10 "2023-06-29T09:43:34Z")
> [@Darren\_Murphy](#):
>
> do you mind if I have a quick look?
> You’ll just need to direct me to the correct App and screen to look at.
That would be really helpful.
It’s Gigs 4.2 and the screen is the Dashboard - the chart is the last one on the current page. 🙂
Thanks a ton.
---
### Author:  [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)
#### Post date: [June 29, 2023, 9:51am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/11 "2023-06-29T09:51:43Z")
@mondrew Hey Mondrew.
A limitation of big tables is it’s use of the computed columns across other glide features:
to use it’s computed columns for filtering a collection or performing roll ups or even use them in charts. Try using the chart labels from a column that is not computed, it could be a text, url, number etc. column.
---
### Author:  [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)
#### Post date: [June 29, 2023, 9:53am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/12 "2023-06-29T09:53:14Z")
Because big tables queries data, it does not allow the use of computed columns across other features. I don’t know why exactly but it could be designed to reduce the load on the server.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 29, 2023, 9:56am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/13 "2023-06-29T09:56:52Z")
Okay, I just had a look, and I still can’t see any reason why that can’t be selected. I’m going to see if I can replicate this, and if it looks like a bug, I’ll report it.
However, wouldn’t it make more sense to make your Gigs 3.1 Months table the source of the chart?
You already have the month names and unique IDs in that table, so you could use those build a relation/query to the Stats table and pull in the data for each month, then use that in your Chart.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 29, 2023, 9:58am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/14 "2023-06-29T09:58:50Z")
> [@Alaap\_Kanchwala](#):
>
> to use it’s computed columns for filtering a collection or performing roll ups or even use them in charts. Try using the chart labels from a column that is not computed, it could be a text, url, number etc. column.
In this case, the source column is not a computed column. However, he is trying to use a Big Table computed column as a chart label, which may explain why it doesn’t work.
I think he’s approaching this from the wrong direction, though - see my reply above.
---
### Author:  [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)
#### Post date: [June 29, 2023, 10:05am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/15 "2023-06-29T10:05:29Z")
> [@Darren\_Murphy](#):
>
> You already have the month names and unique IDs in that table, so you could use those build a relation/query to the Stats table and pull in the data for each month, then use that in your Chart.
This is worth a shot!
---
### Author:  [@mondrew](https://community.glideapps.com/u/mondrew)
#### Post date: [June 30, 2023, 10:13am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/16 "2023-06-30T10:13:22Z")
> [@Darren\_Murphy](#):
>
> You already have the month names and unique IDs in that table, so you could use those build a relation/query to the Stats table and pull in the data for each month, then use that in your Chart.
Thanks for your help, Darren. I don’t actually have the Month names in that table. I could add them, however, I’d like to truly understand how the BigTables work when it comes to relations and queries. Either way, I’d love to know how to do this.
Thanks again! Drew
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 30, 2023, 10:25am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/17 "2023-06-30T10:25:13Z")
> [@mondrew](#):
>
> I don’t actually have the Month names in that table.
They were there when I looked.
I’m talking about the Gigs 3.1 Months table - the one that has/had only 12 rows. One for each month of the year, with the first column being the month names.
Why don’t you make this table the source of your chart?
That’s what I’d do. Seems to make much more sense to me.
---
### Author:  [@mondrew](https://community.glideapps.com/u/mondrew)
#### Post date: [June 30, 2023, 11:04am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/18 "2023-06-30T11:04:25Z")
> [@Darren\_Murphy](#):
>
> I’m talking about the Gigs 3.1 Months table - the one that has/had only 12 rows.
Darren,
That table doesn’t have the user’s data. It’s a source table I’m using. The user’s data is in the Months Stat’s table. It still doesn’t explain how I could get those tables joined to show the related field in the chart. (Regardless of my use case.)
Andrew
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 30, 2023, 11:10am UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/19 "2023-06-30T11:10:35Z")
Yes, I understand that it doesn’t contain the users data, but that doesn’t change my suggestion. What I am suggesting is using that table as a helper table - it seems to me that this is a classic use case.
Try it - add a query column to that table that matches rows in the Gigs 3.1 Data table using the signed in users email address and This Row-\>Unique Month ID as filters. That should give you a separate result for each row (month). Then add a rollup through that query to get the Y-Axis values for your chart, and you’re done.
---
### Author:  [@blairrorani](https://community.glideapps.com/u/blairrorani)
#### Post date: [January 19, 2026, 10:46pm UTC](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273/20 "2026-01-19T22:46:54Z")
Sorry for reviving this thread, but I think I have a similar issue.
I have used glide tables and related one table to another, pretty standard stuff.
I tried to replace the relation with one to a big table, and all I get is Query in each row of the relation column and data no longer displays in the computed columns based on the relation, e.g. roll up.
Is this not possible?
In [the docs](https://www.glideapps.com/docs/big-tables) I found:
- **Single Value columns** : Cannot target a Big Table directly but work via **[Multiple Relations](https://www.glideapps.com/automation/computed-columns/relations#building-multiple-relations)** or **[Queries](https://www.glideapps.com/docs/automation/computed-columns/query-column)**. Only Single Value → First is supported. _What does this mean?_
- **[Lookups](https://www.glideapps.com/docs/lookup-column)** into Big Tables (eg. Lookups via Multiple Relations or Lookups that target an entire Big Table column) are supported in Multiple Relations and Queries but limited to 100 matching rows.
Need to get this working asap so any input appreciated a lot!
[Next page](https://community.glideapps.com/t/accessing-related-table-data-in-big-tables/63273.md?page=2)