# Creating an in another table **URL:** \ **Category:** Ask for Help\ **Created:** [January 7, 2024, 3:57pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330 "2024-01-07T15:57:16Z")\ **Posts on this page:** 17\ **Page:** 2
**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:** [January 7, 2024, 7:45pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/21 "2024-01-07T19:45:58Z")
You’re really close based on what I saw in your last video. It’s just a matter of correcting that Lookup column to pull the current balance out of Column H. Then you will have that lookup value to pass back through column H to update your operation balance. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 7, 2024, 7:52pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/22 "2024-01-07T19:52:50Z")
Actually, I am making the update in the Account Balance table. ---
**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:** [January 7, 2024, 8:02pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/23 "2024-01-07T20:02:58Z")
I know, that’s the point of the ‘Single Value → Whole Row’. You use it to create the link from the Operations table to the Accounts table. Then the Lookup column retrieves the current balance from Column H so you then have a value that you can use in your Set Column action to write the current balance back to the operation balce column through Column H. Column H is connecting to the one specific row in the accounts table that you want to update, pulls a column value, and then passes it back to another column. I think rather than trying to make sense of how it works initially, let’s just get it set up and then it should become clear. You have have Column H set up correctly. Now let’s work on the Lookup column and not worry about the action just yet. Just trust me on this. > [@Jeff\_Hager](#): > > Rather than you Lookup column showing `Relation -> Column H` it should be showing `Column H -> Curr Bal OP`. Sorry, I wasn’t clear on that. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 7, 2024, 8:17pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/24 "2024-01-07T20:17:41Z")
Okay, I have made the change. ---
**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:** [January 7, 2024, 8:26pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/25 "2024-01-07T20:26:47Z")
Now set up the action, which will be linked to the Operation table. You can do that through the a tion editor or you can do it directly from the button. What you will be doing is adding a Set Column action where the Row is Column H. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 7, 2024, 8:33pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/26 "2024-01-07T20:33:33Z")
The drop does not show a column H ---
**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:** [January 7, 2024, 8:35pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/27 "2024-01-07T20:35:38Z")
Can you show screenshots of both the Column H configuration and the action editor? ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 7, 2024, 8:47pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/28 "2024-01-07T20:47:01Z")
With that link, shouldn’t it allow me to see the Account Balance table? ---
**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:** [January 7, 2024, 8:48pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/29 "2024-01-07T20:48:47Z")
Pretent that Column H is the Account Balance table. It’s like a shortcut, but to one specific row in that table. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 7, 2024, 8:53pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/30 "2024-01-07T20:53:59Z")
The drop-down in the action ![Jeff2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e88ce6daecf45176bdc5e38a4f35813cfc6014cf.jpeg) does not show column H. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 7, 2024, 8:59pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/31 "2024-01-07T20:59:09Z")
If I do a custom screen what table will control that screen? ---
**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:** [January 7, 2024, 9:08pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/32 "2024-01-07T21:08:35Z")
I’m guessing that the screen that contains the button is not part of the Operations table so it’s not showing you the correct options. I finally sat down at my computer and created a video demonstrating how to set it up. Sorry, there is other stuff going on in my house right now, so I wasn’t able to record sound at the moment. Hopefully I went slow enough to follow along. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 7, 2024, 9:33pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/33 "2024-01-07T21:33:03Z")
I hope this works. Now to delete rows in the Savings Account I will have to link them the same way? By the way, I did not see the drop-down under “This Item” ---
**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:** [January 7, 2024, 9:55pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/34 "2024-01-07T21:55:50Z")
> [@Benjamin\_Strickland](#): > > By the way, I did not see the drop-down under “This Item” Are you saying that you still have a problem, or that this was the problem and isn’t now? > [@Benjamin\_Strickland](#): > > Now to delete rows in the Savings Account I will have to link them the same way? Would you be deleting a single row or multiple rows in the Savings Account table? If its a single row, then yes it would be similar. You just wouldn’t need a lookup column and the action would be a Delete Row action. If you are deleting multiple rows, then you will need to use a multiple relation instead of the single value → whole row. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 7, 2024, 10:27pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/35 "2024-01-07T22:27:04Z")
First, thank you for being so patient with me. I certainly appreciate it. Even if everything does not all work your time has been very valuable. I have completed the screen I wanted. I am dealing with live data so I am making a copy of the present database so when I test the screen and data is deleted I can replace the live data back into the system. Is that a good strategy? ---
**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:** [January 7, 2024, 11:34pm UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/36 "2024-01-07T23:34:52Z")
I do a lot of work directly in my live app. If it’s new functionality that I can add quickly, I’ll just add it where it belongs. If it’s something that will take me several days to develop, I may add conditional visibility on buttons or screens so only I will see them. As for data, I guess whatever works for you. I usually don’t touch live data unless I have my own rows that are filtered only to me or I use Row Owners. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [January 8, 2024, 12:16am UTC](https://community.glideapps.com/t/creating-an-in-another-table/69330/37 "2024-01-08T00:16:01Z")
Yes, that Row Owners I am looking at now myself so I will know what is disclosed and what should not. [Previous page](https://community.glideapps.com/t/creating-an-in-another-table/69330.md?page=1)