The value of third drop down to be dependent on the selection from 1st and 2nd drop down

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

The value of third drop down to be dependent on the selection from 1st and 2nd drop down

Post by BittenApple »

Hello team,

I have 3 dropdowns that are working successfully; but I want the third drop down entries dependent on the selection from the second dropdown.

1- First dropdown: Plan
2- Second dropdown: Hospital
3- Third dropdown: diagnosis

I thought I should list for each hospital only those diagnosis codes that belong to that hospital not all the diagnosis codes.

Second solution is my third drop down, picks up its value from the result of the first and second dropdown:

When I click on first and second dropdown, I get a list as:

diagonsiscodes rate1 rate2

flu 0.5 0.6
coronaVirus 0.1 0.3

Can the third dropdown gets its data from the top, which is the result of first and second dropdown?
Regards,
Bit

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: The value of third drop down to be dependent on the selection from 1st and 2nd drop down

Post by HansV »

See your other question of today.
Best wishes,
Hans

BittenApple
BronzeLounger
Posts: 1498
Joined: 01 Mar 2015, 02:03

Re: The value of third drop down to be dependent on the selection from 1st and 2nd drop down

Post by BittenApple »

Thanks for it!!!