recall the item for description

[Guest]

ITEM DESCRIPTION
____ _____________
item1 item1 description
item2 item2 description
item3 item3 description
item4 item4 description
item5 item5 description


here is my question, how can I just type "item1", then "item1 description"
will show on DESCRIPTION column

 

[Pat Hartman]

Create a query that joins the Item table to the table with the descriptions.
chose the ItemID from the Item table and the description from the
description table. When you type into the item field, Access will
automagically populate the description. To use this feature properly, make
sure that you lock the form field for the description so that it isn't
changed accidentally. Changing it will affect ALL instances of Item1. Base
your form/report on this query.

 

[Guest]

Where? Form, report, or query?

 

[Guest]

How about Form and Table

Where? Form, report, or query?