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
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?