Terry,
Just noticed that according to your message, status_table has an FK
to project... Wouldn't you want the opposite if a project has just
one status? (other than that what others and myself suggested in this
thread is still correct).
projects_table
--------------------------------
id int (pk)
projectname varchar
status_id int (fkey to status_table id)
status_table
------------------------------
status_id int (pk)
status_name varchar
Andrus
On Dec 21, 2006, at 2:34 AM, Terry Jeske wrote:
projects_table
--------------------------------
id int
projectname varchar
status int
status_table
------------------------------
projectId int (fkey back to projects_table id)
status_name varchar
