Double Filtering a value list

[Ponderosa]

Hi, so I'm struggling with a solution for work. It requires being able to filter a set of records through two different specifications (the first being department [HR, engineering, shipping, etc] and the second is status [active, inactive, or unknown]). I want it so that WITHIN each department only the records with Active and Unknown are displayed on a value list for populating a related table. I know how to do it for one level, but not two.

[dansmith65]

Does this help?...

 

 

[Ponderosa]

Greatly! Got me to where I figured it out. I added a third relation between the two tables and added a auto-field which filtered the statuses automatically. Thanks!