I have a pivot table which dislays a subset of data dependant on certain field selections, from a query in an Access database.
eg field 1, field 2 are drop down menus, I want to limit the details in field 2's menu to the relevant fields from field 1's selection.
if field one equals Blue, field 2's options would be Navy, Cyan etc. but other shades of other colours will not be included.
How od I do this
eg field 1, field 2 are drop down menus, I want to limit the details in field 2's menu to the relevant fields from field 1's selection.
if field one equals Blue, field 2's options would be Navy, Cyan etc. but other shades of other colours will not be included.
How od I do this