[AccessD] Training Location Tables

If each class is only ever in one location, then just put the location ID as
a foriegn key in the tblClasses table.  However, if you may have multiple
locations for a class, then create a tblClassLocations table, which has an
Autonumber (ClassLocationID), the ClassID and the LocationID fields.  Then,
if you are just referring to a class, regardless of location (like if you
are putting in notes about the class...) then just use the ClassID field.
But if you are referring to a class in a particular location, (like a class
schedule), then use the ClassLocationID.

Drew

-----Original Message-----
From: Hollis,Virginia [mailto:HollisVJ at pgdp.usec.com]
Sent: Tuesday, November 18, 2003 6:26 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Training Location Tables


I am setting up a new database for training results. The records are entered
by location, each location has a class & an instructor. Then they track each
students comments about the class & instructor.
 
I am confused on how to set up the table to link the location with the
class. I created a tblLocation, tblInstructor, tblClasses. Would I need a
tblClassDetails that would contain the DetailID PK, ClassID, InstructorID, &
LocationID?
 
Or would I need just a DetailID & LocationID (tblDetailLocation). If so, how
do I connect that to the form to make the entries to the tblDetailLocation?
 
Or do I just add each field, tblLocation, tblInstructor, tblClasses to the
Main table that tracks the students comments?
 
Virginia
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com