# How to reflect changes from one table to another

**URL:** <https://community.glideapps.com/t/how-to-reflect-changes-from-one-table-to-another/52392>\
**Category:** Ask for Help\
**Created:** [October 24, 2022, 4:09am UTC](https://community.glideapps.com/t/how-to-reflect-changes-from-one-table-to-another/52392 "2022-10-24T04:09:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Steve\_Calderon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steve_calderon/32/35453_2.png) [@Steve\_Calderon](https://community.glideapps.com/u/Steve_Calderon)\
**Post date:** [October 24, 2022, 4:09am UTC](https://community.glideapps.com/t/how-to-reflect-changes-from-one-table-to-another/52392/1 "2022-10-24T04:09:29Z")

</div>

Hi folks,  
I need some help with something maybe a little basic but that I don’t understand yet how to do it. I’m having issues with relations. I have two tables, one named “Things” and other named “Categories”. Inside categories I have the category name as shown in image 1. And in the Things table I have a column with the categories name as you can see in the image 2.

My question is how to reflect changes from the table “Categories” to the “Things” table. For example, if I change the first category name to “Trianges” instead of “Blocks”, the column category in the “Things” table remains with the same name, “Blocks” and not the new name “Triangles”.

Thanks in advance, I’m newbie in Glide and I couldn’t figure this out.

 ![Captura de Pantalla 2022-10-23 a la(s) 11.03.29 p.m.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3e1166140425a115ed6800a0736d75fad9502687.png)

 ![Captura de Pantalla 2022-10-23 a la(s) 11.02.43 p.m.](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3fc8b2e19a1c65790da6a454b3dd7ee38d951d9d.png)

---

<div class="post-metadata">

**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:** [October 24, 2022, 4:23am UTC](https://community.glideapps.com/t/how-to-reflect-changes-from-one-table-to-another/52392/2 "2022-10-24T04:23:45Z")

</div>

Add a RowID column to your Categories table. Then in your Things table, store the category’s RowID instead of name. Then change your relation to link the category’s RowID to the stored RowID in the Things table.

Don’t hard set the category name inside the Things table. Only store the categorycs Row ID. A Relation and Lookup column can lookup the correct category name through the relation.

A name can change, but RowID never will, so in many cases it’s better to use Row ID’s to build relations.

---

<div class="post-metadata">

**Author:** ![Steve\_Calderon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/steve_calderon/32/35453_2.png) [@Steve\_Calderon](https://community.glideapps.com/u/Steve_Calderon)\
**Post date:** [October 27, 2022, 10:57pm UTC](https://community.glideapps.com/t/how-to-reflect-changes-from-one-table-to-another/52392/3 "2022-10-27T22:57:23Z")

</div>

Thank you so much Jeff!

---

<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:** [October 28, 2022, 10:57pm UTC](https://community.glideapps.com/t/how-to-reflect-changes-from-one-table-to-another/52392/4 "2022-10-28T22:57:27Z")

</div>

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