<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff size=2>That
depends on whether an object can have more than one Location, Supervisor
etc. Your second solution allows as many combinations as you need.
The first allows each to have one.</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff size=2>I
would think you would have:</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2>Employees</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2>Evaluators</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2>Locations</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff size=2>and
Supervisors</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2>Assuming:</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff size=2>Each
Employee has one supervisor, then the Employee table has a Foreign Key
SupID</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff size=2>Each
Employee has one location, then the Employee table has a FK
LocID</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff size=2>Each
Employee has one Evaluator, then the Employee table has a FK
EvID</FONT></SPAN></DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=125450315-03042003><FONT face=Arial color=#0000ff size=2>You
haven't really expressed the relationships of all the objects. Do
Evaluators have locations? Do supervisors have locations? Only
one? If only one then an ID field directly in the Evaluator table to
relate the Evaluator to the location. If more than one, then a M-M table
relating the evaluator to many locations.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of
</B>Hollis,Virginia<BR><B>Sent:</B> Thursday, April 03, 2003 9:58
AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD]
Table for Emp, Location, etc<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=660005214-03042003>On setting up a
tables for employees, evaluators, their locations and supervisors. Is it
better to create a table for each (location, employee, supervisor, evaluator)
then in each table have the locationID, supervisorID, etc. Or is it better to
have each table & join it together in one table with only the key
fields, EmpID, SupervisorID, LocationID, EvaluatorID?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=660005214-03042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=660005214-03042003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>Is email taking over your day? Manage your time with eMailBoss. Try it
free! <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV></BODY></HTML>