autolookup

[BOB O]

Hello,
I have limited knowledge of access. i need to create a
simple database that adds information to a table. i would
like to create a form that automatically fills in the
first and last name fields when an id number is entered.
(this info is located in a seperate table.) the person
would then fill in the rest of the record with the
additional information to populate the new table with all
of this info. is there a simple way to do this? i used
the online help in access, but is was not clear to someone
who isn't already thoroughly versed in the product.
i need to know the basics of how to structure this.

thanks,
Bob o

 

[Roxie Aho]

You might try a Combo Box on your form that takes ID,
First and Last from the table where your names are located.

If the Toolbox is not visible, use View, Toolbox. Make
sure the Control Wizards button (top row, right) is
selected. Select Combo Box and follow the instructions in
the Wizard.

I suggest you store the ID number in your new table.
Storing both first and last in two different tables breaks
the rules of normalization and leads to trouble. You can
display them on the form in unbound text boxes if your
users need to see them after selecting.

Roxie Aho