[AccessD] Multiple Tables

Yep. If you insist on tbl_Main, make it a query not a table, but I still don't see how it benefits you.
 
Arthur Fuller
Technical Writer, Data Modeler, SQL Sensei
Artful Databases Organization
www.artfulsoftware.com




----- Original Message ----
From: "Hollis, Virginia" <hollisvj at pgdp.usec.com>
To: accessd at databaseadvisors.com
Sent: Monday, February 19, 2007 11:50:19 AM
Subject: [AccessD] Multiple Tables


Tbl_Main is just where most of the other fields are, the data.
Anyway....

So would tbl_Model have all the ID fields (FKs?) from each of the other
tables and a description of the Model? All the other tables would just
have their own PK & description?