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