How to use AutoLookup when adding or changing values?

C

CraftHer

I have an entry form that saves information to customer table. One of the
fields in the customer table is Preference. The valid values for Preference
are stored in tblPreference. When I choose a Preference for a customer, I am
storing the Preference ID from the tblPreference.

When I enter or change a Preference ID for a customer, I want the Preference
description from tblPreference to show in a text box on the form. I will not
be using this text box to add/change preferences, only to view.

Please explain to me, with as much detail as possible, how do I have the
description field automatically populated when the preference field is added
or changed?
 
Top