Hello wanted to see how to go about separating lists. I have a list for year make & model and the first two lists work great but when I click on one of the car makes it opens up the same models on every make. I am trying to make it so I can input the individual models for every make.
You need to use filters in your collections. Here is a documentation that you might like:
1 Like
Hello there, welcome to Glide’s community forum 
Glide University as well as Glide Docs are good places to learn. You might want to have a look at filtering a collection and relations.
I tried but couldn’t figure out how to use the filter.
Another video that might help:
In your table where you have makes, you should have a structure to create a multiple relation to the models table.
Makes Table
| MakeID | Make |
|---|---|
| 1 | Toyota |
| 2 | Honda |
| 3 | Ford |
Models Table
| ModelID | MakeID | Model |
|---|---|---|
| 1 | 1 | Corolla |
| 2 | 1 | Camry |
| 3 | 1 | RAV4 |
| 4 | 2 | Civic |
| 5 | 2 | Accord |
| 6 | 2 | CR-V |
| 7 | 3 | Mustang |
| 8 | 3 | F-150 |
| 9 | 3 | Explorer |
Display the relation as your collection source for Models inside a Make. Allow adding more models inside a Make, record the current Make ID to keep the relation between the Make and the newly added Model.
2 Likes
I understand what you are saying and it makes sense but I can’t figure out how to put it together.
1 Like
Make sure (no pun intended) that you have 2 tables, named exactly how Thinh named them, with the exact columns that Thinh showed you.
Now in the “Makes” table, create a relation column pointing to the “Models” table. The column you are using to relate the two tables is MakeID. When you create the relation, tick the “Match multiple” box, because a given make has multiple models in it.
Once the relation is set up, you can pull data from the models table into the makes table with lookup columns.
(Once you get that to work and understand how it works, add to each table basic columns called “Row ID”. Now relate those columns instead of the MakeID column which was created for you as a simplified example to illustrate what a relation is.)
2 Likes
U guys truly are amazing for taking time to help me out but I can’t get it right for some reason. I figured out how to make a relation but not how to put it together
Where exactly are you stuck?
Screenshots are really helpful.
I did exactly as they said and it still does not filter out the models in the makes section it just showed them all
If it’s not working for you, then you must have gone wrong somewhere. If you can show us what you did, then maybe we can help spot where the mistake is.
Great, thanks. That helps a lot.
Okay, I can spot a few problems.
Firstly, in your Makes table, the Make column is User Specific. That is wrong, and will cause you all sorts of problems. So you should delete that and create it again, and make sure you don’t check the User Specific box.
Secondly, your relation is wrong. You are trying to match the Make ID (which is a number) with the Model (which is a string). This will never work. You need to match like with like. So you should match the Make ID in the Makes table with the Make ID in the Models table.
2 Likes
Mauricio, I say the following with good intentions.
This is an honest mistake, the User Specific checkbox feels like a random checkbox, but it has important consequences, and these consequences are not immediately clear.
This shows you have zero clue what you are doing. And it’s totally okay of course. I would recommend you spend some time in Glide Docs or Glide University to get a grasp of the fundamentals. Understanding some of the fundamentals will allow you to go a long way.
1 Like