AND OR Statement - Link AND records together and still use OR option

How to only show specific linked records?
Not sure how to best describe this ...

I am trying to set-up user prompts to enter the member numbers + the test code specific to that member.

My current prompts shows all tests codes entered to all the member numbers that happens to have the test codes.

Did that make sense?

So I enter a specific member number = 1 and I only want to view the record for test code "A" BUT I also enter another specific member number = 2 and want to view test code "B"

Since member number = 2 also taken test "A" it shows up because it was entered for member number = 1.

So instead of seeing:
Member number = 1 and Test "A"
Member number = 2 and Test "B"

I'm getting:
Member number = 1 and Test "A"
Member number = 2 and Test "A"
Member number = 2 and Test "B"

Hope that made sense?

How can I set-up the user prompts so that only the specific test code(s) to the specific member number shows up?

The other way is for the user to go into Select Export and do this:

Code:

---

{vw_tests_reprints.prs_USFSA_No} = 6297046  and
{vw_tests_reprints.tst_TestCode} in ['pm'] or

{vw_tests_reprints.prs_USFSA_No} = 8783100  and
{vw_tests_reprints.tst_TestCode} in ['pjm'] or

{vw_tests_reprints.prs_USFSA_No} = 6493175  and
{vw_tests_reprints.tst_TestCode} in ['jm']

---