Avatar of Jay Carax
Jay Carax
 asked on

Designing Outlook form

Hello,

I have two drop down menus, one called 'Floor' and the other called 'Area'. I want it so that when I select a type of floor, it will dynamically update the area drop down with relevant items. Can someone please show me how to link them?

An example would be

Floor
Values =   Basement, Ground

 
If Floor = Basement    

then values in Area should only display:  Bike Store, Kitchen, Boiler Room

If Floor = Ground
then values in Area should only display: Reception, Lift Lobby, Library

Please see attachment for a basic visual.

Thanks
image001--1-.png
Outlook

Avatar of undefined
Last Comment
Jay Carax

8/22/2022 - Mon
Tony Giangreco

This link takes you through the entire process. Hope it helps!

http://www.slipstick.com/developer/designing-custom-forms/
ASKER CERTIFIED SOLUTION
Jamie McKillop

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jay Carax

ASKER
Thanks - I will take a look at these now.
Jamie McKillop

I just noticed a mistake. insert the line:

Case "Ground:

before:

#If Floor equals "Ground"
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Jay Carax

ASKER
Thanks!