[AccessD] Re: Changing the table in a query so I canloopthrough thequery

Yes. They are the parts tables for our Bill of Materials system. They are
organized by type: tbl023 is Gaskets, tbl076 is Transformers, etc. The
tables are structurally identical, with room for 8 attributes. Needless to
say, one size does not fit all: tbl006, Elbows, requires 3 attributes, while
tbl003, Heaters, requires over 30! The solution to the latter problem is, of
course, more bad design: either create an auxiliary table to hold the extra
attributes, or dump them into a big note field.

Welcome to my inherited mess!

-Ken

-----Original Message-----
From: Robert L. Stewart [mailto:rl_stewart at highstream.net]
Sent: Monday, April 19, 2004 3:53 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Re: Changing the table in a query so I canloopthrough
thequery


Ken,

You have been in my SIG long enough to know that is a resounding YES, it is
a bad design.  But, do you actually populate all 140 tables with the same
data like she is doing?

Robert