Conditional Drop Down List??
The heading maybe incorrect but let me explain;
I have 3 Tables;
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.
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.