Thank you all for your input. Michael asked me "What exactly do you need?". Which is a good question:
- We need a way to track projects. - Projects will be displayed to the user in a grid, which should be sortable by Name, and Status. - Status values are: "Completed", "In Progress", "Not Started" - The current status values may change over time. For example "Not Started" may change to "TBD". - The user can change the status of a project by selecting a value from a HTML list box. - An admin user can add (and edit) values to the status table through a web form, and these changes are immediately available to the website - i.e. list box values are populated from the database. Adding a new Status requires no code changes, it is purely database driven. I know that this example is a bit contrived i.e. "status" would normally stay a bit static. However, there are other cases where these values may change, and having them in a Key table should not be a big deal (IMHO <g>). I should note that I am not a DBA, but I know enough to get by, usually by running queries until I get the syntax right. My focus is on the integration side of things, but like many of us, I have to wear many hats. On 12/20/06, Juergen Saar <[EMAIL PROTECTED]> wrote:
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 > > > >