Query - easy question
Posted on 2015-01-15
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.