[AccessD] Lookup Fields in Table Design

DWUTKA at marlow.com DWUTKA at marlow.com
Sun Mar 28 04:05:58 CST 2004


I'll take the hit, but I'm curious, how would you paraphrase what Ken is
saying?

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
To: Access Developers discussion and problem solving
Sent: 3/27/04 3:53 PM
Subject: RE: [AccessD] Lookup Fields in Table Design

unnecessarily derogatory remark -.5 sayers

Score: nay-sayers 4 / sayers 7.5

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
DWUTKA at marlow.com
Sent: Saturday, March 27, 2004 11:59 AM
To: accessd-bounces at databaseadvisors.com; accessd at databaseadvisors.com
Subject: RE: [AccessD] Lookup Fields in Table Design


Thank you!  I was beginning to think that I was talking to a wall there.
Everything I have tested shows that the DefaultControl property does
absolutely nothing to how JET retrieves data, and only slightly affects
how
JET stores data (because it does setup a relationship, if you have an ID
field with a lookup of a related table.  But it's no more 'work' then if
you
just set the relationship up in the database, in the first place.

All I'm getting from Ken is, 'It's just not standard practice, so it
must be
bad'.  Ugh.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
To: Access Developers discussion and problem solving
Sent: 3/26/04 8:26 PM
Subject: RE: [AccessD] Lookup Fields in Table Design

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.



--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list