I'm creating a template that will provide me with multiple billing rates for attorneys.
There are three criteria which will determine the values of the billing rates, (Title, Track, Class Year).
I have used drop down boxes to provide me with all of the relevant options for each of these field
Title = Partner or Associate or Other
Track = On Track or Off Track
Class Year = all years between 2020-2010
When the value "Associate" is selected in the first drop down (Title), then the second (Track) and third (Class Year) drop downs need to be completed.
What I would like to do accomplish is when "Associate" is NOT selected in the fist drop down box (Title), then the second and third drop down boxes would auto-populate to "n/a". But is "Associate" if selected then the second and third drop down need to display the options in the list above.
Thoughts?
Bookmarks