Arthur Fuller
artful at rogers.com
Tue Jun 1 20:21:11 CDT 2004
No need for the CustomerID since I have the CustomerClassificatonID, which implies the CustomerID via a simple join. The question is, given the choice in the XXXX table to store the CustomerClassificationID or the ClassificationID, then which to store? On reflection, I think I just answered my own question. If I have the CustomerClassificationID I have both the CustomerID and the ClassificationID, by implication. Question withdrawn! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Tuesday, June 01, 2004 11:47 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] A Database Design Question Wouldn't you want to put the ClassificationID and CustomerID into the CustomerClassifications table? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Sunday, May 30, 2004 11:53 AM To: AccessD Subject: [AccessD] A Database Design Question I have 4 tables (actually lots of instances of this setup, but for simplicity let's deal with one only): Customers -- obvious CustomerDetails -- many Details for each Customer Classifications -- a list of generic classifications CustomerClassifications -- a table containing only the Classifications of interest to a given Customer The general idea is this. We populate Classifications with lots of commonly-used items such as Admin, User, Manager, etc. We populate CustomerClassifications using a combo and a NotInList event that allows the addition of new Classifications that aren't already in the Classifications table. When the user adds new CustomerDetails, we see only the Classifications of interest to said Customer (i.e. draw them from CustomerClassifications and get the text value for the combo from Classifications). Still with me? I hope so. Here's the question: should the table CustomerDetails store the CustomerClassicationID or the ClassificationID? TIA for opinions. Arthur -- _______________________________________________ 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