Arthur Fuller
artful at rogers.com
Wed Jun 22 13:34:46 CDT 2005
My $.02... I hate such naming conventions, for three reasons: a) they defeat the natural logic of the various relationship-finding wizards; b) there is no need to prefix the column names since you can do so unambiguously using the table name as a prefix (i.e. Customers.CustomerID = Orders.CustomerID). c) the prefixes hide the relationships while admittedly revealing the table sources... but if we are really going to go in this direction, I would rather use suffixes (i.e. CustomerID_Customers, CustomerID_Orders, CustomerID_Payments etc.) -- so they are logically grouped together according to domain type rather than table name. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: June 22, 2005 2:11 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Field Naming ( Just once I want to be ahead of JC ) My gosh, I had an idea that drew liked too. Joe Hecht Los Angeles CA -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Subject: RE: [AccessD] Field Naming ( Just once I want to be ahead of JC ) Not a bad idea. Drew -----Original Message----- From: Joe Hecht [mailto:jmhecht at earthlink.net] Sent: Wednesday, June 22, 2005 11:37 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Field Naming ( Just once I want to be ahead of JC ) When naming fields in table design view I try to prefix the field with something to identify the source table i.e.: Custfname custLname repfname replname Joe Hecht Los Angeles CA -- 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