AnsweredAssumed Answered

Conditional Drop Down List??

Question asked by arthursc on Sep 15, 2011
Latest reply on Oct 10, 2011 by arthursc

Title

Conditional Drop Down List??

Post

The heading maybe incorrect but let me explain;

I have 3 Tables;

Estate

Primary Location

Secondary Location.

Each ESTATE can have multiple PRIMARY LOCATIONS.
Each PRIMARY LOCATION can have multiple SECONDARY LOCATIONS.

I have an issue with SECONDARY LOCATIONS layout. There are 3 fields to this layout;

ESTATE Name (Dropdown list from Estate Table)

PRIMARY Location Name (Dropdown list from the Primary Locations Table)

Secondary Locations Name.

The Issue.

When I select Estate Name it appears and populates the field as you'd expect.
When I select Primary Location Name it displays ALL locations for ALL records in the Primary Locations Table and not those that releate to the Estate Name I have selected in the first field.

How can I resolve this so that which ever ESTATE is selected from the first dropdown list, only the Location values relating to the selected Estate are displayed in the PRIMARY Location Name dropdown List

Your help in this would be appreciated.

Regards

Colin

Screen_Shot_2011-09-21_at_17.52.11.png

Outcomes