[AccessD] Subdatasheet vs. Relationships?

Mark,

Your apology accepted.  I took no offense since I did not make my point
as clearly as I should have.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Mitsules, Mark [mailto:Mark.Mitsules at ngc.com] 
Sent: Friday 2003 Aug 22 08:47
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Subdatasheet vs. Relationships?

Charles,

You're right of course?  My apologies for seeing arrogance where
apparently there was none?


Mark


-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
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
-----Original Message-----
From: Mitsules, Mark [mailto:Mark.Mitsules at ngc.com] 
Sent: Friday 2003 Aug 22 08:14
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Subdatasheet vs. Relationships?
Importance: Low


Well Charles...that is a fine horse you have...highest one I've seen
this week.


Mark



-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Friday, August 22, 2003 8:20 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Subdatasheet vs. Relationships?


Christopher,

What gives is that you inherited a db from someone that knew nothing
about db design.  My condolences to you.  It may be easier to throw it
away and start from scratch.

Charles Wortz
-----Original Message-----
From: Christopher Hawkins [mailto:clh at christopherhawkins.com] 
Sent: Thursday 2003 Aug 21 16:01
To: accessd at databaseadvisors.com
Subject: [AccessD] Subdatasheet vs. Relationships?

I have inherited an A2K database that has numerous tables related to one
another via the SubDatasheet property. Make no mistake, I hate this
feature with a passion because it slows databases down. 
However, if there is a legitimate reason to use it I'll buy in.

The db has no relationships defined in relationships view. In the mdb is
a main form based on a single table (no JOINS in the RecordSource), with
several subforms on tabs. Each subform is getting data from a single,
distinct tables (that is, no two subforms use the same table for data.
All subforms are linked to the main form by BlahID.

Now, for the life of me, I can't figure out what using the SubDataSheet
property of the tables does to help this application. 
What gives?

-Christopher-