[AccessD] Subdatasheet vs. Relationships?

In truth, I'm told that the original developer was *not* meeting the
requirements put forth to him.  I inherited the database mainly
because of all the data in it.  But I'm not going to be too hard on
the guy - he's a purchasing clerk, not a developer.  This project was
dumped on him, was out of his area of expertise, and he performed
accordingly.

It may not be what they wanted, but it *is* highly salvageable.  I'm
going to refactor it in many ways, including the elimination of all
subdatasheets.

I can't complain too loudly.  It's nice to get a couple days of work.


-Christopher-

---- Original Message ----
From: Mark.Mitsules at ngc.com
To: accessd at databaseadvisors.com, 
Subject: RE: [AccessD] Subdatasheet vs. Relationships?
Date: Fri, 22 Aug 2003 10:42:41 -0400

>All,
>
>My skin must be a little thin today.  I realize the truth in what's 
>been
>said, but my comments were more in defense for the "little guy".  
>Based on
>the fact that this database was 'inherited' at all says that the 
>"developer"
>was in fact providing some value with his solution and that it was 
>meeting
>the requirements of the time...or at least meeting what requirements 
>he was
>capable of providing.  To discount that person's efforts so 
>callously was,
>IMO, arrogant.  I stand by that assertion.
>
>
>Mark
>
>
>-----Original Message-----
>From: Arthur Fuller [mailto:artful at rogers.com] 
>Sent: Friday, August 22, 2003 10:19 AM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] Subdatasheet vs. Relationships?
>
>
>Despite my earlier mailing I have to concur. Relationship 
>definitions are
>Everything in a db design, IMO (well, assuming PKs etc.).
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Wortz, 
>Charles
>Sent: Friday, August 22, 2003 9:22 AM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] Subdatasheet vs. Relationships?
>
>
>Mark,
>
>If the developer didn't use relationships and instead used 
>subdatasheets,
>then I contend that they do not know about database design.  A 
>person that
>understands database design would set up relationships.  They may 
>also use
>subdatasheets, but that is not the point.
>
>Charles Wortz
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003
>
>_______________________________________________
>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
>
>