# Settings values in tables not configured as the data source in the screen **URL:** \ **Category:** Ask for Help\ **Created:** [March 1, 2024, 11:26am UTC](https://community.glideapps.com/t/settings-values-in-tables-not-configured-as-the-data-source-in-the-screen/71322 "2024-03-01T11:26:20Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![stomgb](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@stomgb](https://community.glideapps.com/u/stomgb)\ **Post date:** [March 1, 2024, 11:26am UTC](https://community.glideapps.com/t/settings-values-in-tables-not-configured-as-the-data-source-in-the-screen/71322/1 "2024-03-01T11:26:20Z")
Hello Gliders, I have two screens, each is sourced to a **different** source table - Table A (Sessions, with a pk called session\_id) and Table B (Tools, with a user specific column called active\_session). As the user interacts with tools, I want to update specific columns in both tables based on a shared value - the unique session id. For example, a user starts the workflow in table A by selecting a session. I now have the session id at hand and the user email (identifier) and need to set these two user-specific columns in table B (tools). How do I do that? Second example - when a user selects and interacts with a tool (second screen backed by table B), I’d like to update specific columns in table A (sessios) for that session. I can store (with a user specific column) the session\_id and user\_id in the tools table, but then I can’t find an option in the set values action to set a value of a specific row in the sessions table (i.e a table not configured as the data source for the screen). ---
**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 1, 2024, 12:02pm UTC](https://community.glideapps.com/t/settings-values-in-tables-not-configured-as-the-data-source-in-the-screen/71322/2 "2024-03-01T12:02:21Z")
In each scenario, do you need these values in _all_ rows in the other table, or in one specific row? - If all rows: Use a Single Value Column - If a specific row: You need to create a single relation from one table to the other, then you can Set Column Values via that relation. Alternatively, set the initial values in your User Profile row instead, then you can access them from any table/screen. ---
**Author:** ![stomgb](https://avatars.discourse-cdn.com/v4/letter/s/87869e/32.png) [@stomgb](https://community.glideapps.com/u/stomgb)\ **Post date:** [March 1, 2024, 10:35pm UTC](https://community.glideapps.com/t/settings-values-in-tables-not-configured-as-the-data-source-in-the-screen/71322/3 "2024-03-01T22:35:25Z")
Amazing, so helpful!! As suggested I added an Active Session column to the Users table and also added a Relation column to the Sessions table. Indeed, the User profile columns are always available so this way I am able to go from Users to Sessions to Tools from any screen in the app. I’ve also updated [this](https://community.glideapps.com/t/guidance-for-multi-page-form-entry-workflow/71144/3) thread accordingly. Thanks! ---
**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 8, 2024, 10:35pm UTC](https://community.glideapps.com/t/settings-values-in-tables-not-configured-as-the-data-source-in-the-screen/71322/4 "2024-03-08T22:35:51Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.