Auto Look-up Queries

[Colleen B.]

I have created a form that contains information regarding
employees. The form is based on a query that links my
employee table (which lists all employees - this is
my "one" table) to a call log table (list of calls that
employees call in regarding issues/problems - this is
my "many" table. I am linking on Social Security No. I
have currently have it set up when I enter a social
security no, it does a autolook up and fills in the
employee name, address, birthdate, etc. That work
gerats . . . however, they want the ability to enter
either the SSN# or the employee name and have it autofill
the other information. Can I do an autolook on more than
one field?

 

[Jeff Boyce]

Colleen

I still don't understand which of the two approaches I mentioned is the one
you are using. Or, you could be using a Filter-by-example approach.

When you say "it does a autolook up and fills in the
employee name, address, birthdate, etc.", my question is HOW does it
currently do that?

Please review my original response -- it includes at least one way to do
what you're asking.

Good luck

Jeff Boyce
<Access MVP>