DWUTKA at marlow.com
DWUTKA at marlow.com
Thu Jun 3 11:45:36 CDT 2004
Actually, it's a limit that would have to grow. Next year, the upper group would be 56, so the limit would move up one. <grin> Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Brett Barabash Sent: Thursday, June 03, 2004 11:27 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] OT: The Great Primary Debate 55? Drew, you of all people shouldn't advocate arbitrary upper limits! How about 255? -----Original Message----- From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] Sent: Thursday, June 03, 2004 11:02 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] OT: The Great Primary Debate What do you think the cut off is for understanding a lookup field? 55? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of jwcolby Sent: Thursday, June 03, 2004 10:46 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] OT: The Great Primary Debate LOL. Always the troublemaker. You do realize if an old-style developer can't understand a surrogate key, they SURE won't understand a lookup attached to the FK right in the table design. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, June 03, 2004 11:12 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] OT: The Great Primary Debate Well, if you use a lookup field with foriegn keys, you can 'see' also! <VBG> (Just had to toss that into the mix). Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of jwcolby Sent: Wednesday, June 02, 2004 4:15 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] OT: The Great Primary Debate Yea, I tend to agree with you. In fact during the great debate that was one of the "arguments" for using natural keys... What if ... I can always look at the data and see... John W. Colby www.ColbyConsulting.com ---------------------------------------------------------------------------- ---------------------------------------- The information in this email may contain confidential information that is legally privileged. The information is only for the use of the intended recipient(s) named above. If you are not the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or the taking of any action in regard to the content of this email is strictly prohibited. If transmission is incorrect, unclear, or incomplete, please notify the sender immediately. The authorized recipient(s) of this information is/are prohibited from disclosing this information to any other party and is/are required to destroy the information after its stated need has been fulfilled. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Tappe Construction Co. This footer also confirms that this email message has been scanned for the presence of computer viruses.Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com