I am trying to set up a script on my database to do the following:
First select from a value list a fuel type, eg oil, gas, electric
Have the script identify what the fuel type is, then go to another field and display another value list that relates to the fuel.
eg choose gas, in the field displays forced air, boiler
or choose oil, in the field displays hydronic, radiant
Could someone please help