# Depending on the selected dealer, the list should include specific cars that are under this dealer and not all available cars
**URL:** https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341
**Category:** Ask for Help
**Created:** [July 25, 2023, 7:17am UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341 "2023-07-25T07:17:25Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@vchupilka](https://community.glideapps.com/u/vchupilka)
#### Post date: [July 25, 2023, 7:17am UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/1 "2023-07-25T07:17:25Z")
Hi to all.
I am creating a small application. I have seven dealers, each dealer has a certain number of cars. When choosing a dealer from the list, the cars of this particular dealer should be displayed. At the moment, it shows all the cars of all dealers
I make the application based on Airtable.
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [July 25, 2023, 7:39am UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/2 "2023-07-25T07:39:43Z")
Hello, welcome to the community forum.
**In the Data Editor**
- Cars table: Car name. Dealer name.
- Dealers table: Dealer name. Multi-relation to Cars table along Dealer name.
**In the Layout Editor**
- Add a collection with data source Dealers table. Item click is show detail screen.
- On Dealers detail screen, add a collection with data source the multi-relation.
For more information about `relations`.
> **[Glide • Relations](https://www.glideapps.com/docs/reference/computed-columns/relations)**
>
> Create relationships and link rows together.
(For a more advanced setup of your relation, you would relate row ID rather than category name, since row IDs will not change but names might.)
---
### Author:  [@vchupilka](https://community.glideapps.com/u/vchupilka)
#### Post date: [July 26, 2023, 2:33pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/3 "2023-07-26T14:33:15Z")
Hello, thanks for your help.
But i still cant understand how to make - “When choosing a dealer from the list, the cars of this particular dealer should be displayed”.
I choosed a dealer and then i saw all cars from other dealer too.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 26, 2023, 2:36pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/4 "2023-07-26T14:36:41Z")
Are you using the relation as the source of the collection?
> [@nathanaelb](#):
>
> On Dealers detail screen, add a collection with data source the multi-relation.
---
### Author:  [@vchupilka](https://community.glideapps.com/u/vchupilka)
#### Post date: [July 26, 2023, 2:48pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/5 "2023-07-26T14:48:00Z")
Iam using a cars table as sourse of a collection.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 26, 2023, 3:21pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/6 "2023-07-26T15:21:09Z")
I thought you wanted to start with a list of Dealers, select a Dealer, and then show a list of Cars that are related to that Dealer?
How would you expect that to work if you start with a list of Cars?
@nathanaelb gave you the steps:
> [@nathanaelb](#):
>
> **In the Data Editor**
>
> - Cars table: Car name. Dealer name.
> - Dealers table: Dealer name. Multi-relation to Cars table along Dealer name.
>
> **In the Layout Editor**
>
> - Add a collection with data source Dealers table. Item click is show detail screen.
> - On Dealers detail screen, add a collection with data source the multi-relation.
Have you tried following those steps?
Have you created the multiple relation column in your Dealers table that matches the Dealer name with the same value in the Cars table? This is the key thing that you need to do to make this work. Once you have that relation, you use it as the source of a collection on your Dealers details screen (the screen you see when you click on one of the Dealers).
---
### Author:  [@vchupilka](https://community.glideapps.com/u/vchupilka)
#### Post date: [July 26, 2023, 4:03pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/7 "2023-07-26T16:03:42Z")
Yes, everything is correct.
I want to make it so that when choosing a dealer from the list, only the cars of the dealer I chose are displayed in the next window.
I made the necessary connection. Screenshot below:
But when I choose a dealer, I see all cars and other dealers as well.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [July 26, 2023, 4:22pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/8 "2023-07-26T16:22:04Z")
Did you change the source of the Cars collection on your Dealer detail screen to use the relation?
---
### Author:  [@vchupilka](https://community.glideapps.com/u/vchupilka)
#### Post date: [July 26, 2023, 4:28pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/9 "2023-07-26T16:28:08Z")
Soory, but I am new in Glide, can you show where Ican choose this?
We are talking about this (thsi is dealers choise screen) ?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [July 26, 2023, 4:34pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/10 "2023-07-26T16:34:30Z")
Does your button take you to a detail screen for the dealer? What’s the action on your button?
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [July 26, 2023, 4:38pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/11 "2023-07-26T16:38:54Z")
Hi @vchupilka,
Nathan and Darren already provided the solution! Just adding this video that maybe helpful!
> **[Dealers and Cars.mp4](https://drive.google.com/file/d/1TroDhMLNEDSQVC1Cb2K_upEWPDKmJwb4/view?usp=sharing)**
>
> Google Drive file.
If my setup is different from the way you have setup-ed let me know!
Thank you
---
### Author:  [@vchupilka](https://community.glideapps.com/u/vchupilka)
#### Post date: [July 27, 2023, 12:45pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/12 "2023-07-27T12:45:13Z")
Thanks !
Everything works
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [July 28, 2023, 12:45pm UTC](https://community.glideapps.com/t/depending-on-the-selected-dealer-the-list-should-include-specific-cars-that-are-under-this-dealer-and-not-all-available-cars/64341/13 "2023-07-28T12:45:14Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.