Value Query

[Kathy]

I have one table with a list of MANAGERS where the
primary key is an AutoNo. I want to write a query that
will change the AutoNo to the MANAGERNAME in my form.

 

[John Vinson]

I have one table with a list of MANAGERS where the
primary key is an AutoNo. I want to write a query that
will change the AutoNo to the MANAGERNAME in my form.

A couple of ways to do this:

Base the Form on a query joining whatever table it's now based on to
MANAGERS, joining the ManagerID to the MANAGERS primary key. Select
the manager name from the MANAGERS table as the control source of the
textbox.

Or, use the toolbox Combo Box wizard to create a combo box bound to
the managerID but displaying the manager name.