[AccessD] Lookup Fields in Table Design

In essence, the lookup property(ies) of a field in a table are no different
to the Format, and Caption properties. They are used to define the *default*
way that the data in the table is displayed in the GUI.  You can overwrite
this default in any query grid, form control, report control that you
create.

It has nothing to do with how a recordset is actually retreived by Jet.

===========Absolutely true, as I understand them. Lookup field properties
are implemented at the Access level, via user-defined field properties.
There's no difference between a lookup field and any other field. As I've
said many times now, they're a GUI trick -- one that users can quickly and
efficiently enable with little to no other knowledge. 

Susan H.