Query search by Customer Name

[Anthony Strickland]

I am very new to building databases within Access, and I have ordered some reference material to help me with the simple things, but I do not have it yet and I am trying to build a query that will search my "Sales Order" table by the field "Customer Name". This field is linked through a lookup mechanism within the design portion of the "Sales Order" table to another table named "Customer List". What expression do I need to input into the criteria portion of the query I am trying to build to make it prompt me for the Customer Name?

Any help would be greatly appreciated.

 

[DJN]

Enter Like [Enter a customer name] & "*" in the criteria for the Customer field.