Select A Value List Based On Calculation
I am trying to accomplish the following, but I don't know if it can be done. The example below is hypothetical to easily relate.
There are 2 value lists, "Ford" and "Chevy" Ford value list has "Mustang" & "Focus", Chevy value list has "Impala" and "Malibu".
I have a field called "Manufacturer" and one called "Model". If the user selects "Ford" in the "Manufacturer" field, I want the "Model" field to display a drop down list of the "Ford" value list (Mustang or Focus), for the user to select from, and not display the items in the Chevy value list and visa-versa
Any help would be appreciated.