# Selecting a record in one table and displaying the associated records from another **URL:** \ **Category:** Ask for Help\ **Created:** [August 15, 2023, 5:28pm UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055 "2023-08-15T17:28:33Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![kcrane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kcrane/32/62929_2.png) [@kcrane](https://community.glideapps.com/u/kcrane)\ **Post date:** [August 15, 2023, 5:28pm UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/1 "2023-08-15T17:28:33Z")
New to Glide but I was doing quite well, until… I have two tables in Airtable, Table A and Table B. Table A links to several records in Table B. I’d like one or both of these options: First a page that has a list of Table A records. When you click on one of the records a new page appears with a list of the associated Table B records. In the second example there is only one page, at the top is a Choice which selects from Table A and when a choice is made, the associated items from Table B appear below. I went around in circles trying to see what filter I used and how I chose the field to filter on from a different table from the one I was filtering… Thanks for any help! ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 15, 2023, 7:13pm UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/2 "2023-08-15T19:13:42Z")
Hi @kcrane, Welcome to the community 🥳 Check this out! : [Table A and B.mp4 - Google Drive](https://drive.google.com/file/d/1q8ByMu6wvBB0d5HyzwMxphzn5P_Na9ip/view?usp=sharing) Thank you ---
**Author:** ![kcrane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kcrane/32/62929_2.png) [@kcrane](https://community.glideapps.com/u/kcrane)\ **Post date:** [August 16, 2023, 7:28am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/3 "2023-08-16T07:28:09Z")
@dilon_perera Thank you for that, I understood some but not all of the steps. Did you need to create ‘dummy’ columns converting AT linked records to text? ---
**Author:** ![kcrane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kcrane/32/62929_2.png) [@kcrane](https://community.glideapps.com/u/kcrane)\ **Post date:** [August 16, 2023, 11:16am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/4 "2023-08-16T11:16:03Z")
Maybe I should have read/watched more intros before jumping in. The Glide Uni videos on relationships answers my questions. I find the screen/page concept a bit confusing as, if I have it right, creating a page actually creates the top level of what can become a series of sub-pages unless you specifically navigate to another page. Eg click on an item in a list, a new page appears, yet that page isn’t in the page list. But that newly created page can access info from the top level page, which is what I wanted 😀 ---
**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:** [August 17, 2023, 12:14am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/5 "2023-08-17T00:14:31Z")
> [@kcrane](#): > > First a page that has a list of Table A records. When you click on one of the records a new page appears with a list of the associated Table B records. If I understand you right, what you need for your first option to work is just to navigate to details screen of table A records, then display a collection citing the relation from table A to table B records. > [@kcrane](#): > > In the second example there is only one page, at the top is a Choice which selects from Table A and when a choice is made, the associated items from Table B appear below. For this, it would write a table A’s rowID to a user-specific column. You would then create a relation from that value to the corresponding column in table B, and display that in a collection. ---
**Author:** ![kcrane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kcrane/32/62929_2.png) [@kcrane](https://community.glideapps.com/u/kcrane)\ **Post date:** [August 17, 2023, 6:34am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/6 "2023-08-17T06:34:16Z")
Thank you, yes that’s right @thinhdinh. I hadn’t realised that screens are actually a stack of screens and that the detail screen is built-in. The shorthand of calling it a details screen made me miss that it is actually ‘the screen that is displayed when you click on an item in a collection’. I also hadn’t realised that screen ’stacks’ aren’t independent of each other, so that if I start on one screen and I am clicking on an item in a collection showing Table A it shows the detail screen for Table A. If start in a separate screen, and show a collection of Table A, then the same details screen appears. In other words detail screens are attached to collections as you said, It would aid my understating Glide better if detail screens could be selected directly in the editor, for example being included in the properties of the collection on the right hand side, along with sort and group etc. I’m now working out how I get two details screens for one collection. Sometimes whenI click on an item I do need to edit the items in my table and other times I want to see a list of related records in another table. ---
**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:** [August 17, 2023, 6:57am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/7 "2023-08-17T06:57:37Z")
> [@kcrane](#): > > I’m now working out how I get two details screens for one collection. Sometimes whenI click on an item I do need to edit the items in my table and other times I want to see a list of related records in another table. For this use case you can use the “Show New Screen → This Item” action. ---
**Author:** ![kcrane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kcrane/32/62929_2.png) [@kcrane](https://community.glideapps.com/u/kcrane)\ **Post date:** [August 17, 2023, 8:04am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/8 "2023-08-17T08:04:36Z")
Ooh, thanks @darren_murphy That’s something I could assign to a button or used advanced actions and change the click on an item action? ---
**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:** [August 17, 2023, 8:06am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/9 "2023-08-17T08:06:13Z")
Yes, certainly. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [August 18, 2023, 8:38am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/10 "2023-08-18T08:38:10Z")
Sorry for the late reply! Here’s a detailed video : [Table A and B detailed.mp4 - Google Drive](https://drive.google.com/file/d/1PIE-c4MzxOCAJjfqh-CHhiQ2NzmEMYj6/view?usp=sharing) ---
**Author:** ![kcrane](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kcrane/32/62929_2.png) [@kcrane](https://community.glideapps.com/u/kcrane)\ **Post date:** [August 18, 2023, 10:01am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/11 "2023-08-18T10:01:37Z")
Thank you very much for that detailed explanation, much appreciated 👍🕶 ---
**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:** [August 25, 2023, 10:01am UTC](https://community.glideapps.com/t/selecting-a-record-in-one-table-and-displaying-the-associated-records-from-another/65055/12 "2023-08-25T10:01:43Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.