Quick Search Query from Two Tables (Question)

[Guest]

Sorry - last one accidentally posted as "Suggestion"

I have two tables: tblEvaluation and tblCustomer. The tables are linked by a
primary key that resides in tblCustomer (atnCustNo) and is linked to
intCustNo tblEvaluation.

I also have a form that displays evaluation information based on
tblEvaluation. I have a quick lookup dropdown that allows the user to select
the date/time of the evaluation and I WANT them to also be able to see the
name of the client that is tied to that Evaluation. How can I do this? I
currently have the SQL below, but I need to incorporate the field
tblCutomer.chrCustName into the current query.

SELECT dtmEvalDate, intCustNo FROM tblEvaluation;

 

[Douglas J. Steele]

Answered in your first post.

 

[Guest]

Thank you VERY much - once again, you gave me the perfect answer!