I have a custom object of
The issue I'm having is how do I accomplish 1) only showing makes on Opportunity page from custom object when make is clicked and 2) only show models on Opportunity page from custom object that match the make selected?
- row1: make: toyota, model: camary
- row2: make: toyota, model: highlander
- row3: make: audi, model: a6
On Opportunity page, when user clicks make field, only toyota and audi will be presented in "dropdown"
On Opportunity page, when user clicks model field and toyota was selected for make, "camary' and "highlander" will be presented in "dropdown"
From the example data, need 1) when click make, all unique models are shown in dropdown, 2) when click model, all unique models related to make are shown in dropdown.
I originally set up Lookup Relationship for both custom fields make and model on Opportunity but the problem is when select make, the entire row from the custom object is shown "audi a6".