Multiple filters, dependent on previous selection

[Amy.H]

Hi,

I'm trying to create multiple filter lists:
Region --Select---
Year --Select---
Sector --Select---
Name --Select---

To filter a database

The database would be something like:
Region Year Sector Name Value
London 2011 x1 abc 1
Yorkshire 2011 x1 cde 1
London 2010 x1 abc 2


But I want the filter values selected in, for example, Region to then limit the values that can be selected from the other filter fields (Year, Sector and Name). So if I selected "London" (from the region filter options) I would only want the values available for the Year, Sector and Name that occurr for London.

If anyone has any ideas please could they let me know. Any help would be greatlly appreciated

Many thanks

[Fotis1991]

Hi

An autofilter does this. Did you tried it?