Can and how do I create a query for the current record only?

[Dilly]

I am trying to qualify a record in one table(1) (local input, name and test
scores) based on criterion in another table(2) (10 test scores qualify for
certain positions) and then report from tables 1, 2 and 3 (locations)

It looks something like this:

Table 1 Name Scores
AA BB CC DD...

Table 2 Position AA BB CC DD
job 1 90
job 2 95
job 3 90
job 4 85

Table 3 Position Location
job1 New York
job2 Los Angeles
job3 New York, Los Angeles

if AA is =>90, print name, job 1, location. This works fine if I only have
one record in Table 1. As soon as I have multiple records it queries for
each record.

Can and how do I create a query for the current record only?