Mike and Doris Manning
mikedorism at ntelos.net
Thu Aug 21 16:06:57 CDT 2003
Other than to help the original programmer see the data at the bottom level easily... Not a thing... Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher Hawkins Sent: Thursday, August 21, 2003 5:01 PM 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- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com