Avatar

Level 5

Good day All;

With any luck, this will be the final touches I will need to get this form ready for approval.

Anyway…. This is what I am trying to do. When using dropdown lists, I would like to be able to select from a group of managers depending on what “Section” was selected. It gets a little more crazy (to me anyway).

Example: There a 3 divisions with 1 director per division.

                 Each division has 4 or more sections with a manager for each section.

So that being said, what I would like the user to be able to do is:

If user selects Division “1” the “director” field will auto populate with “Director 1” name.

Next, when the user selects a “Section” from the dropdown, they will only be presented with a list of sections that belong to “Director 1”. When they make the selection, the “manager” is auto populated with the manager’s name…….

Please let me know if I have gone a wee bit over the deep end with this.

I hope this made sense??? ;>))

Thanks All

Chomp