My company is trying to put together a form with dependent picklists that would be used to indicate a Make and Model of cars. So for example, Picklist 1 would be Honda, Toyota etc. Picklist 2 would be the specific model based on picklist 1, so Honda -> CRV, HRV, Accord, etc.
As you can imagine, there are tons of models for each make. Chevrolet itself has almost 400.
I'm trying to figure out the best solution, considering there is a limit on dependent picklist values that we would definitely exceed. I'm an Admin so I am not familiar with all of the custom solutions, but I do have access to developer resources. I just need to be able to suggest the best route.
Thanks!
Ashley
3 answers
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Ashley,
The best way I can think of would be to create a new custom object called "Models".
Just add an extra field in this custom object called "Make". The name of each model would be the model itself (CRV, HRV, etc) and the make would just be the make itself.
Now create a picklist on the object with all the makes
Create also a lookup field to the Model object with a required filter Object: Make equals Field Model: Make
Now populate the custom objects with all your makes and models, ie:
Record 1: Make: Volkswagen Model: Golf
Record 2: Make: Volkswagen Model: Polo
Record 3: Make: Honda Model: CRV
Record 4: Make: Honda Model: HRV
etc
Now when you select a Make, you can only search on the related models
