I am new to the MS Access world, so I hope I communicate my issue correctly.
I am creating a Quality Assurance Database where I have 2 Tables
TestCase and Test Result History

Testcase Table has
ID, Name,Test Desc,Type. TestArea, product and Release

TestResultHistory has
TestCaseID, build, date tested,platform,tester and result

They are connected ID to TestCaseID - relationship.

If I fill out the records and navigate between the records, everything works fine. I am trying to Filter by Type. TestArea, product and Release, but they are tied to the records and they keep changing.

My question is how can I have those fileds independent of the records so that I can filter by the dropdown values?