# About Master/Detail Record Update **URL:** \ **Category:** Ask for Help\ **Created:** [March 20, 2022, 12:11pm UTC](https://community.glideapps.com/t/about-master-detail-record-update/39863 "2022-03-20T12:11:11Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Pentametrics\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pentametrics_admin/32/40584_2.png) [@Pentametrics\_Admin](https://community.glideapps.com/u/Pentametrics_Admin)\ **Post date:** [March 20, 2022, 12:11pm UTC](https://community.glideapps.com/t/about-master-detail-record-update/39863/1 "2022-03-20T12:11:11Z")
I am new to Glide. I am wondering how to update Master table when detail is updated. For example, i have a status column with starting value as “New”. I want to update that column to “Open” when a record added in Detail table or “Completed” when a detail record is updated. I see a solution like having single value but not sure how to do that or if you have a better approach, kindly help me. ---
**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:** [March 20, 2022, 12:22pm UTC](https://community.glideapps.com/t/about-master-detail-record-update/39863/2 "2022-03-20T12:22:49Z")
You’ll need a MasterID column in your Detail table. You can use that to create a [relation](https://docs.glideapps.com/all/product/data-editor/relations) between your Master table and your Detail table. If that relation is not empty, then you have a related Detail record. If you need to check the values of specific columns in your Details table, then you can use [lookups](https://docs.glideapps.com/all/topics/computed-columns/primary/lookup-column) through that relation. To return a different Status value based on conditions, you can use an [if-then-else](https://docs.glideapps.com/all/topics/computed-columns/primary/if-then-else) column. ---
**Author:** ![Pentametrics\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pentametrics_admin/32/40584_2.png) [@Pentametrics\_Admin](https://community.glideapps.com/u/Pentametrics_Admin)\ **Post date:** [March 20, 2022, 1:29pm UTC](https://community.glideapps.com/t/about-master-detail-record-update/39863/3 "2022-03-20T13:29:02Z")
Yes Darren, like what you said i have in my app. I am able to save records on both master and detail. Also I can use if-then-else to display different status on the screen. But my question is, how i will update master table physically with a new status code when something changed in detail? ---
**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:** [March 20, 2022, 1:31pm UTC](https://community.glideapps.com/t/about-master-detail-record-update/39863/4 "2022-03-20T13:31:58Z")
So you want to save the status in a non-computed column in your Master table? Okay, so you just need to create a Single Relation from the Detail table to the Master table. Then when something changes in the Detail table, you can do a Set Column values through that relation to update the status in the related Master record. ---
**Author:** ![Pentametrics\_Admin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pentametrics_admin/32/40584_2.png) [@Pentametrics\_Admin](https://community.glideapps.com/u/Pentametrics_Admin)\ **Post date:** [March 20, 2022, 1:40pm UTC](https://community.glideapps.com/t/about-master-detail-record-update/39863/5 "2022-03-20T13:40:54Z")
Excellent. Good to learn that. Thank You Darren, have a great week. ---
**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:** [March 21, 2022, 1:41pm UTC](https://community.glideapps.com/t/about-master-detail-record-update/39863/6 "2022-03-21T13:41:49Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.