auto fill field in form with lookup from another entry

[GUEST]

i have a table with employee number and name. in a form - how can i enter the employee's name and have it automatically fill in the employee's number?

 

[J]

Any form you create will not "fill in" the employee
number. You can create a form that calls the employee name
value and the employee number value. You must have a
table, or tables, with those fields already existing.

Just create a form that calls those two values--and more
if you want. What you'll do is either scroll through the
records the form is calling from the table, or you can put
your cursor in the Emp Name field, hit Contrl-F for find,
and search by name. When the record is called matching the
fame you searched for, the form will show you the name
value and the employee number value. Now you can see the
employee number you wanted to see, right? If there isn't
one filled in yet, you can do so now and save that value
to the table.

-----Original Message-----
i have a table with employee number and name. in a form -

how can i enter the employee's name and have it
automatically fill in the employee's number?

 

[guest]

i already have a table setup with all employee numbers and names contained. The form will be used to add classes these employees have taken- which is stored in another table- so on a record by record basis this information can be retained. i just wanted it to be easier for my user to simply enter the employee's name and have the form automatically fill in emp# from the emp table.

 

[Art]

Hi Guest,
You could put a combo box on your form. When the user
picks his name in this box, the rest of his information
including the employee number could be "filled in" on the
form. Is this what you meant? If so, use the combo box
wizard from the tool bar and follow it along.

Hope This Helps

-----Original Message-----
i already have a table setup with all employee numbers

and names contained. The form will be used to add classes
these employees have taken- which is stored in another
table- so on a record by record basis this information can
be retained. i just wanted it to be easier for my user to
simply enter the employee's name and have the form
automatically fill in emp# from the emp table.