# Mirroring data (colums) between 2 tables **URL:** \ **Category:** Ask for Help\ **Created:** [November 29, 2024, 10:41am UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255 "2024-11-29T10:41:23Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Peter\_Boye](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_boye/32/82525_2.png) [@Peter\_Boye](https://community.glideapps.com/u/Peter_Boye)\ **Post date:** [November 29, 2024, 10:41am UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/1 "2024-11-29T10:41:23Z")
Hello, I have 2 tables with the same names and addresses. I would like to set up a kind of mirroring of the columns so that if I change the address in one table, for example, it is automatically changed in the other table. That should also apply to columns with, for example, telephone numbers. Does anyone have a solution? I haven’t found anything similar here. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 29, 2024, 10:59am UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/2 "2024-11-29T10:59:28Z")
The standard way to do this is to have one table that is the source of truth, and then pull the needed values into any other tables as computed columns using relations and lookups. > **[Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations)** > > Create relationships and link rows together. > **[Lookup | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/lookup-column)** > > Retrieve values through a relation. ---
**Author:** ![Peter\_Boye](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_boye/32/82525_2.png) [@Peter\_Boye](https://community.glideapps.com/u/Peter_Boye)\ **Post date:** [November 30, 2024, 9:11pm UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/3 "2024-11-30T21:11:04Z")
Thanks, Unfortunately, I’m not very familiar with the application yet. Can you describe the process to me? I’ve tried a few things, but I haven’t come to any conclusion. I have a table called “Students” which contains, among other things, the column “Address”. The second table “OGS” also has the column “Address”. The names are also in both tables. I’ve set up row IDs for both tables. ---
**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:** [November 30, 2024, 11:40pm UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/4 "2024-11-30T23:40:58Z")
In the “OGS” table, you should store the student’s ID, or any pieces of info that is unique to the student. Then, create a relation using that student ID back to the Students table, and retrieve the address using a lookup on top of the relation. That way, you just need to edit the address for the Students table, and it will be updated in the OGS table. ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [December 1, 2024, 10:28am UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/5 "2024-12-01T10:28:50Z")
Yes, but how do you handle the situation when new entries are added in the OGS table? ---
**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:** [December 1, 2024, 11:58am UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/6 "2024-12-01T11:58:41Z")
Good question, I’m assuming once the flow is set for him, he will add data on the Students table first. ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [December 1, 2024, 1:12pm UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/7 "2024-12-01T13:12:42Z")
Hm, it sounded as if the initial question was related to “automatic mirroring” of tables. So I am assuming that it is an identical table - not some other attributes that could be indeed resolved via relationships. This identical mirroring could be interesting when trying to bring data that is for instance in a GS table to Glide. ---
**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:** [December 1, 2024, 2:31pm UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/8 "2024-12-01T14:31:34Z")
Yeah, without any further clarifications from the poster, if the tables have to stay that way, it would have to involves relations & set columns on both sides. However, I feel like we might be able to adjust the data structure, hence the suggestion. ---
**Author:** ![Peter\_Boye](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_boye/32/82525_2.png) [@Peter\_Boye](https://community.glideapps.com/u/Peter_Boye)\ **Post date:** [December 1, 2024, 3:26pm UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/9 "2024-12-01T15:26:35Z")
These are different tables. Only the personal data is identical, such as name, first name and address.I would like to maintain this data in the student table. The OGS table is not filled with new data. New students are always entered in the student table. ---
**Author:** ![Peter\_Boye](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_boye/32/82525_2.png) [@Peter\_Boye](https://community.glideapps.com/u/Peter_Boye)\ **Post date:** [December 1, 2024, 6:07pm UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/10 "2024-12-01T18:07:39Z")
Thanks to everyone for the quick and uncomplicated help. After a few attempts I managed to get it to work the way I wanted. ---
**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:** [December 8, 2024, 6:07pm UTC](https://community.glideapps.com/t/mirroring-data-colums-between-2-tables/78255/11 "2024-12-08T18:07:47Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.