Create an AutoLookup query that automatically fills in data

For AutoLookup to work on new records, certain conditions must be met. For more information, click .

1. Create a select query, adding two tables that have a one-to-many relationship.

   How?

2. Add the fields for the query to the design grid.

   You must include the join field from the "many" side of the one-to-many relationship.

   

3. If you want, specify criteria in the Criteria row to select specific records.

   How?

4. To view the query's results, click View on the toolbar.

   When you enter new data in the join field on the "many" side of the relationship, Microsoft Access will automatically look up and fill in the corresponding data from the "one" side.

Note   For information on troubleshooting an AutoLookup query, click .