Hi I need a favor regarding pick-list selection.
for example: I have a Location object. In Location object I have (County name) field. I created county 1, county 2, county 3. And I have another object Candidates. In Candidates object I have created a record with name County Location. here in this County Location record you get options of County 1, 2, 3 with the a lookup relation with Location object. In same Candidates object I have a pick list with hospital names. Hospital 1, 2, 3. When I choose County 1 option in County Location record field, I would like to see hospital 1 option in pick-list. Please help me with suggestions, how can I achieve this.
Thanks a lot!