-- Child Entity of Location
--- JobStage; JobStageID (PK)
I am wondering how to implement this in such a way that certain locations are associated with a certain Job Stage (Not Started, Processing, Complete). I would like to link it so that the stage is transparent to the user. Just by selecting a Location, it will be associated with the corresponding JobStage.
Here is a simple map of my Relationship as I have it.
I do not disagree, but I am still wondering how I would most logically have the DB know simply by a LocationID what the JobStage was... I know I could program this to be done with some Select Case... but I feel like there is a way to do it with the relationships of the database.
I am willing to spend the extra time to learn this, as this is a learning project... but if I am totally wrong as the Select Case is the most logical way (even if this were large scale) then I would like to know that too..