Enetring text into parameter query for an id

[scottappleford]

Hi

I want to create a query where the field being reference is an employee ID in a purchase orders table.

I have a sperate employee table with all the employees in and the employee ID in the other tables is set so that it displays the name in the forms.

I would like to set the query up so that when i type the name into parameter query or search form it is not looking for the employee ID number but the employee name that is typed?

Many Thanks for your help

scott

 

[RuralGuy]

I want to create a query where the field being reference is an employee ID in a purchase orders table.

I would like to set the query up so that when i type the name into parameter query or search form it is not looking for the employee ID number but the employee name that is typed?

So you need two different query's?