# Master Table Referencing

**URL:** <https://community.glideapps.com/t/master-table-referencing/67195>\
**Category:** Ask for Help\
**Created:** [October 22, 2023, 9:58pm UTC](https://community.glideapps.com/t/master-table-referencing/67195 "2023-10-22T21:58:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![speisenkarte](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@speisenkarte](https://community.glideapps.com/u/speisenkarte)\
**Post date:** [October 22, 2023, 9:58pm UTC](https://community.glideapps.com/t/master-table-referencing/67195/1 "2023-10-22T21:58:15Z")

</div>

Hi I’m having what feels like an elementary issue using the calculated columns. I made a custom unique ID with a template column and can use it to query another table in one instance, but not in another. Attached is a visual of how the data is mapped.

Users define a project profile which fills multiple “component” tables with a rows of data. The user can then “submit” the project which adds a single row to the master table, including the unique ID. The unique ID is a reference for query columns in the master table to pull in the relevant rows from the component tables. I use a query instead of a relation since two qualifiers are needed: the project-specific unique ID and a category ID. The master table has no trouble relating to a single row in one table or querying multiple rows in another, but replicating the latter has proven challenging.

Thank you!

 ![Master Table Query Mapping](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b4e6756b0c456c3f6d1ac9ee6e15096c81ea5e3.png)

---

<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:** [October 22, 2023, 11:39pm UTC](https://community.glideapps.com/t/master-table-referencing/67195/2 "2023-10-22T23:39:59Z")

</div>

Any chance you have copied and pasted the values at some point in your flow? There’s a data editor bug in the past few weeks that would affect something like what you described.

I would suggest retyping “Item 1” and “Item 2” on your own in table 2 to see if it works.

---

<div class="post-metadata">

**Author:** ![speisenkarte](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@speisenkarte](https://community.glideapps.com/u/speisenkarte)\
**Post date:** [October 28, 2023, 3:04pm UTC](https://community.glideapps.com/t/master-table-referencing/67195/3 "2023-10-28T15:04:31Z")

</div>

Thank you! We were spinning our wheel on that one

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 4, 2023, 3:04pm UTC](https://community.glideapps.com/t/master-table-referencing/67195/4 "2023-11-04T15:04:44Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.