[AccessD] Lookup Fields in Table Design

Stuart McLachlan stuart at lexacorp.com.pg
Fri Mar 26 20:26:07 CST 2004


On 26 Mar 2004 at 19:35, Ken Ismert wrote:

> 
> >It doesn't affect that, BECAUSE it's a property that is only
> >looked at by the Wizards, NOT by Jet, when retrieving the data.
> 
> Its used in queries too. Queries inherit this stuff from the table they are
> based on.
> 

Queries don't use it. The object which Access uses to display the 
results of queries does.

If I pull a "Select * from tblMyTable", my recordset doesn't know 
anything about the combobox bound to fldMyLookup - or about any table 
used for the lookup on that field. If however, I use the Query 
Datasheet to display it, the datasheet will look at the table 
definition to determine how it is displayed by default (which can be 
overwritten by defining a different display format in the query grid 
itself).  

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.



 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.






More information about the AccessD mailing list