# Need to change a value of one table to another table **URL:** \ **Category:** Ask for Help\ **Created:** [November 2, 2022, 11:40am UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115 "2022-11-02T11:40:23Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [November 2, 2022, 11:40am UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/1 "2022-11-02T11:40:23Z")
Hi I have a product table and store pickup table. The business owner updates the available status after a product as bought.it should update the store pickup table. - Happening But i want the product table too should change to bought. How to do it. ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [November 2, 2022, 2:14pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/2 "2022-11-02T14:14:29Z")
Try creating a relation column between the two tables on a common data column and then use lookup column on that relation. ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [November 25, 2024, 9:33pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/3 "2024-11-25T21:33:17Z")
How does one CHANGE the value in the related table? For example I have a table of items that needs to be decremented when an item is included in the order. I can lookup for the value from the orders table to the items count but don’t have a way to change the value? Thanks ---
**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:** [November 25, 2024, 9:38pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/4 "2024-11-25T21:38:36Z")
As long as you have a single relation to that item, you can perform actions through the relation. ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [November 25, 2024, 10:21pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/5 "2024-11-25T22:21:26Z")
in the set column action editor as you know i can select this item (which is the orders table). If I have a relation to the items table in orders I am able to select the count column in from the list of columns? ---
**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:** [November 25, 2024, 10:28pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/6 "2024-11-25T22:28:24Z")
If the action is executed from the orders table and and you have a single relation from the orders table to the items table, then you can select the relation as the data source and set values through that relation. ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [November 25, 2024, 10:30pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/7 "2024-11-25T22:30:36Z")
I’m sure if it was you entering this it would work first time. i see the relation i orders from action editor. select my relation decrement the count value and no change when I look in the data editor. will pound my head against this wall a bit more as there is something i am missing. thanks for the help ---
**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:** [November 25, 2024, 10:35pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/8 "2024-11-25T22:35:14Z")
So you were able to configure the action to use the relation? What’s calling the action? ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [November 25, 2024, 10:42pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/9 "2024-11-25T22:42:42Z")
Jeff - i deleted the action I was previously using and created it from scratch and and it is working. I have seen this behavior in Glide before so I start over and things seem to work better. I have specified a negative increment value -1 but i noticed it add to the count. Hey - I’ll take the win but wanted to confirm that i can increment negative values? THANKS ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [November 25, 2024, 10:45pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/10 "2024-11-25T22:45:05Z")
there are many updated another table posts on the site. This fix is SO easy - if there is a tutorial on this let me know. Have a great T-Day if you celebrate ---
**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:** [November 25, 2024, 11:04pm UTC](https://community.glideapps.com/t/need-to-change-a-value-of-one-table-to-another-table/53115/11 "2024-11-25T23:04:23Z")
> [@Carl\_Johnson](#): > > wanted to confirm that i can increment negative values? Interesting. A negative number should work and the docs mention the same. > **[Increment Value | Glide Docs](https://www.glideapps.com/docs/automation/actions/increment-value#setting-up-the-increment-value-action)** > > Increase or decrease a number by any value. > [@Carl\_Johnson](#): > > tutorial on this let me know. Not sure if there is a specific tutorial, but here is a post from when the feature was implemented back in 2021. > [@new Increment a column through a relation](https://community.glideapps.com/t/increment-a-column-through-a-relation/34885): > > You can now increment a column through a relation. This saves some columns to pre-calculate a value then set it through a set column action, the way we did it before. Happy Thanksgiving to you too.