# Update a value in secondary table which then automatically updates in primary table **URL:** \ **Category:** Ask for Help\ **Created:** [July 3, 2025, 8:09pm UTC](https://community.glideapps.com/t/update-a-value-in-secondary-table-which-then-automatically-updates-in-primary-table/82921 "2025-07-03T20:09:52Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Nana1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nana1/32/86367_2.png) [@Nana1](https://community.glideapps.com/u/Nana1)\ **Post date:** [July 3, 2025, 8:09pm UTC](https://community.glideapps.com/t/update-a-value-in-secondary-table-which-then-automatically-updates-in-primary-table/82921/1 "2025-07-03T20:09:52Z")
Hello! New Glide user here. I’m built a small food diary app. It has a main table (Entries). When adding a new entry, I can select the “meal type” (e.g. “Breakfast”, “Lunch”, …) and a “feeling” (e.g. “Good, no negative effects”, “Bloated”, etc). The meal types and feelings each have their own table. ![Entries table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e00c82cb73e959288eee4b7a983c820aef03def4.png) ![Feelings table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/61d8774f9060eaa5ceb1ff13adac6abfa2e7afe4.png) ![Meal type table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/828539f6a7ffe6552900a482dad9e6877b777c40.png) Everything is working correctly, but the other day I decided I wanted to change the “feelings” labels to have different emojis so they’re more visually distinct (e.g. change “🙂 Good, no negative effects” to “🟢 Good, no negative effects”). I thought that, since the “feeling” column in my “Entries” table was getting the selected value from the “Feelings” table, when I updated the “Feelings” table value it would automatically update all the relevant entries already in the “Entries” table. But instead, it only applies the change to newly added entries. ![Feelings table - updated a value](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/9498447cb95e49b735a116f91dafefa7701b012c.png) ![Entries table - only latest row updated (not all entries)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/b/9bed356cfb0fa3a3d4a4287d9a2857117d2960f0.png) How do I make it so that, when I update a value in the “Feelings” table, that value is updated in all existing entries in the “Feeling” column (in the “Entries” table)? And same question for the meal types. A couple of screenshots of how this looks in the app: ![New entry form - shows updated value from the "Feelings" table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab7301fd1ef9274e6e197998bb36dc1ebdfabb99.jpeg) ![Entries list - the updated "Feeling" value only gets applied to the newest entry, it doesn't update existing entries](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/83a02ceffe9db3d9f84683edafb166798c6b4bb5.jpeg) Any help is appreciated, thank you! ---
**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\ **Post date:** [July 3, 2025, 8:31pm UTC](https://community.glideapps.com/t/update-a-value-in-secondary-table-which-then-automatically-updates-in-primary-table/82921/2 "2025-07-03T20:31:30Z")
Instead of copying the “Name” text from the Feelings table (which it looks like you do) into Entries you could add a rowID to the Feeling table and write the rowID for the matching ‘FEELING’ into the Feelings column (rather than the text from the Name column) in Entries. Then create a Relation (such as rel-\>Feelings) from Entries/Feeling to Feelings/rowID (Entries.Feeling = Feelings.rowID) in the Entries table. You use Glide’s Lookup column type to return the rel-\>Feelings.Name. Now whenever the Feelings table is updated the corresponding data in Entries will reflect the change. ---
**Author:** ![Nana1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nana1/32/86367_2.png) [@Nana1](https://community.glideapps.com/u/Nana1)\ **Post date:** [July 3, 2025, 10:01pm UTC](https://community.glideapps.com/t/update-a-value-in-secondary-table-which-then-automatically-updates-in-primary-table/82921/3 "2025-07-03T22:01:48Z")
Thank you Matt for the quick reply, this worked perfectly! 🙌 ---
**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:** [July 10, 2025, 10:02pm UTC](https://community.glideapps.com/t/update-a-value-in-secondary-table-which-then-automatically-updates-in-primary-table/82921/4 "2025-07-10T22:02:14Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.