AnsweredAssumed Answered

Conditional Drop Down Lists

Question asked by SaugaDrez on Feb 17, 2010
Latest reply on Feb 17, 2010 by philmodjunk

Title

Conditional Drop Down Lists

Post

Hello,

 

I have a database with which I would like to have a conditional drop down list based on the choice in another field.

 

Here is my example data:

Locations Sites

Location A Site A

Location A Site B

Location B Site C

Location B Site D

 

In a sepreate table I have many fields but also Location and Site.  I have defined a relationship for Locations between the two tables.  What I would like to do next is have a "conditional" drop down list in the second table for Sites that depends on my choice for Locations:

 

If I choose Location A, I would like the drop down to display only Site A and Site B

If I choose Location B, I would like the drop down to display only Site C and Site D.

 

Any help would be greatly appreciated. 

Outcomes