# Selecting from detailed list? **URL:** \ **Category:** Ask for Help\ **Created:** [June 20, 2025, 8:25pm UTC](https://community.glideapps.com/t/selecting-from-detailed-list/82637 "2025-06-20T20:25:39Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Pelle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pelle/32/84124_2.png) [@Pelle](https://community.glideapps.com/u/Pelle)\ **Post date:** [June 20, 2025, 8:25pm UTC](https://community.glideapps.com/t/selecting-from-detailed-list/82637/1 "2025-06-20T20:25:39Z")
**Table A** has a one-to-one relation to **Table B**. When editing an item in **Table A** , the user has to see several column values from **Table B** in order to chose the right item from **Table B**. I have tried showing the items from **Table B** in a list, but the action _Set column values_ does not have an option to set column values in **Table A**. How can I solve this other than concatenating column values and show them in a choice component? 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:** [June 20, 2025, 10:08pm UTC](https://community.glideapps.com/t/selecting-from-detailed-list/82637/2 "2025-06-20T22:08:36Z")
Create a single relation from TableB back to TableA. Then you can set column values through the relation. ---
**Author:** ![Pelle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pelle/32/84124_2.png) [@Pelle](https://community.glideapps.com/u/Pelle)\ **Post date:** [June 21, 2025, 8:35am UTC](https://community.glideapps.com/t/selecting-from-detailed-list/82637/3 "2025-06-21T08:35:56Z")
Thanks for your reply. Unfortunately each item in **Table B** can be related to more than one item in **Table A**. It’s a one-to-many relationship from **Table B** to **Table A** but I don’t know how to set that up. ---
**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:** [June 21, 2025, 8:40am UTC](https://community.glideapps.com/t/selecting-from-detailed-list/82637/4 "2025-06-21T08:40:16Z")
So are you saying that you need to set values in multiple rows in table B with a single action? If that’s the case, you would need to use a workflow for that. Would you mind sharing screenshots of both tables, so that we can get a better visualisation of what you have and what you are trying to do. I’ve read your question multiple times, but I’m still not sure I’m clear what the actual goal is. ---
**Author:** ![Pelle](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pelle/32/84124_2.png) [@Pelle](https://community.glideapps.com/u/Pelle)\ **Post date:** [June 21, 2025, 9:08am UTC](https://community.glideapps.com/t/selecting-from-detailed-list/82637/5 "2025-06-21T09:08:46Z")
Hi! I don’t want to share the actual table data but I’ll try to explain myself better. I don’t think my need is unique; the problem is probably that I haven’t understood my own need. For a column in **Table A** , I want to be able to point to a row in **Table B**. I can easily do this with a choice component. The problem with a choice component is that it only displays a single column value to the user. That’s not enough in my case - the user needs to see multiple column values to be able to choose correctly. My solution has therefore been to, in the edit view for **Table A** , display all rows in **Table B** in a list that shows multiple column values. The problem arises when I need to save the row from **Table B** that the user selects. I can’t seem to save the user’s choice in **Table A** since the screen has lost it’s reference to **Table A**. I have attached a screenshot of a simplified mock up of my data. I have probably set it up incorrectly. The reality is that each row in **Table A** is only related to one row in **Table B** , but each row in **Table B** can be related to multiple rows in **Table A**. ![Tables](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bdad87321a03c299fdb06861673410517194ef4a.png) ---
**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:** [June 21, 2025, 9:19am UTC](https://community.glideapps.com/t/selecting-from-detailed-list/82637/6 "2025-06-21T09:19:40Z")
Okay, that’s a bit clearer. Perhaps you could do something like the following: - Add a RowID column to Table A, if you don’t already have one. - When a User views a record in Table A, write the corresponding RowID value to a column in the User Profile row. - Use that to build a (single) query from Table B back to Table A using that RowID value as a filter - You should then be able to Set Column Values in Table A from Table B via that Query ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 22, 2025, 1:03am UTC](https://community.glideapps.com/t/selecting-from-detailed-list/82637/7 "2025-06-22T01:03:10Z")
Can you just have a template column to join column values in table B together to use as the “display as” value for table B?