John W. Colby
jwcolby at colbyconsulting.com
Fri Mar 26 21:53:17 CST 2004
The real answer to this is to just shoot all users. Problem solved! John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins Sent: Friday, March 26, 2004 10:37 PM To: 'Access Developers discussion and problem solving' Subject: RE: [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. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com