How Do You Look Up Values From One Microsoft Access Table And Automatically Insert Them In Another Table?
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. Open your table in Design view. 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. Name your field. Click in the datatype box immediately to the right. A small arrow appears in the right corner. Click in the small arrow to view a menu of choices. Select Lookup Wizard. When the wizard appears, select “I want the Lookup Column to look up values in a table or query.” Follow the wizard’s instructions. Click Finish when satisfied. Save your table. When you loo
