Query - easy question

Dear experts -
I have a subform driven off a temp table (Table 1). It has a control called 'action_ID'.

Now, I want to create a recordset that will select records from a different table (Table 2), where multiple conditions are met, including limiting the 'action_ID' field in Table 2 to those in the temp table (Table 1).

What is the easiest way to do this?

I was thinking of creating a DAO.Recordset, then doing a select statement on Table 2, and either doing a join or a subquery with Table 1.

Your thoughts are appreciated.
terpsichoreAsked:
Who is Participating?
 
bonjour-autConnect With a Mentor Commented:
If table 1 is a real access table, the a query with inner join will do:

SELECT tbl2.*
FROM tbl2 INNER JOIN tbl1 ON tbl2.action_ID = tbl1.action_ID  where ((.............other restrictions.....................));
0
 
terpsichoreAuthor Commented:
thank you - this works just fine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.