How to Look Up Values From One Microsoft Access Table and Automatically Insert Them in Another Table

By eHow Computers Editor

Rate: (6 Ratings)

You can put values from one table into another with a Lookup list. For example, if you were an artist, you might have one table for your paintings and another table for the galleries that display them. With a Lookup list of gallery names from the Gallery table inserted into a field in the Paintings table, you could simply click on the correct gallery from a menu instead of typing it from the keyboard. These instructions apply to MS Access 97.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

Create a Lookup List from Design View

Step1
Open your table in Design view.
Step2
Insert a new row in the spot where you want your new field to appear. If you want to put the new field at the end, click in the first empty row.
Step3
Name your field.
Step4
Click in the datatype box immediately to the right. A small arrow appears in the right corner.
Step5
Click in the small arrow to view a menu of choices. Select Lookup Wizard.
Step6
When the wizard appears, select "I want the Lookup Column to look up values in a table or query."
Step7
Follow the wizard's instructions. Click Finish when satisfied.
Step8
Save your table. When you look at your table in Datasheet view, clicking on the empty field will provide a menu of choices based on the field values that you "looked up."

Create a Lookup List from Datasheet View

Step1
Open your table in Datasheet view.
Step2
Create a new column where you want your new lookup field to appear.
Step3
Name your new field.
Step4
From the Insert menu, select Lookup Column.
Step5
When the wizard appears, follow the same procedures mentioned above.
Step6
Save your table.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Look Up Values From One Microsoft Access Table and Automatically Insert Them in Another Table

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads