Right you are! I was a bit sloppy with my description. Sorry about that.
On 12/20/06, Andrus Adamchik <[EMAIL PROTECTED]> wrote:
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 >
