Thanks for reply.
But when I run a query for specific sales person, I have to mention his "ID" instead of his name. I want Access to Save SalesPerson's name instead of ID. Is it possible?

---

Reply from Alex Hedley:

That's not the advised way.

Why not create a Form and set the data to your Query with a parameter, create another form that lists your Sales People, click on the person and open this form.

Searching by Name instead of ID isn't a good database design.