I would it do in the Andrus-Style ... but it seems, as if the idea of terry is a freetext-status, that is continous changed during the lifecycle of a project. I wonder why this information is not placed directly in the project-table.
2006/12/21, Andrus Adamchik <[EMAIL PROTECTED]>:
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 >
