I have two related picklists and I would like one to drive the possible options for the other.

The first picklist has three market types in it: Coal, Wind, Water. The second picklist is a project type under one of these categories, so, if I pick Coal from the first picklist, I want the Project Type picklist to give me project types that correspond with that energy market. These values are different than those that would display if one picks Wind or Water.

Anyone know if there's a simple way to connect these? I am not terribly Salesforce savvy and don't understand how the coding works yet.

Thanks!

I have two related picklists and I would like one to drive the possible options for the other.

The first picklist has three market types in it: Coal, Wind, Water. The second picklist is a project type under one of these categories, so, if I pick Coal from the first picklist, I want the Project Type picklist to give me project types that correspond with that energy market. These values are different than those that would display if one picks Wind or Water.

Anyone know if there's a simple way to connect these? I am not terribly Salesforce savvy and don't understand how the coding works yet.

Thanks!