Create updatable query based on results of another query

I'm sure I did a terrible job describing my question and hopefully I can do a better job here.

I have a query (final query) that is the result of several other queries. There is a unique field (varietyid) in this query that would have a one to one relationship with table tblVarieties.

Table tblVarieties has a Yes/No field named Selected. I want to create a query that will show all records from the final query and include the Yes/No field from tblVarieties. This will allow the user to select specific records to be used in a report. For example, if the results of the final query contains 40 records, the user can create a report that only shows 5 of the records.

I probably made this way more difficult than it needs to be, but I hope someone can figure out what the heck I'm talking about.

Thanks, DaleStart Free Trial