I am creating a database for a client to use. in it I have an entity called JOB with a one to many relationship to Estimate.
The spec goes like this: The client will produce an estimate for a client (Est 1). The client will want changes (Est 2) and some more changes (Est 3, Est 4, Est 5). At some point the client might say actually I think Est 3 will do fine. I need to have the database keep proper track of the current estimate and be able to select the active estimate.
Furthermore once the Job is underway I need to be able to delete the "other" estimates. Given the relationship Estimate holds the KeyID for Job but how/where can/should I record the selected KeyID for Estimate? I don't really want to have to go searching around the database each time I need to establish what's what.
The spec goes like this: The client will produce an estimate for a client (Est 1). The client will want changes (Est 2) and some more changes (Est 3, Est 4, Est 5). At some point the client might say actually I think Est 3 will do fine. I need to have the database keep proper track of the current estimate and be able to select the active estimate.
Furthermore once the Job is underway I need to be able to delete the "other" estimates. Given the relationship Estimate holds the KeyID for Job but how/where can/should I record the selected KeyID for Estimate? I don't really want to have to go searching around the database each time I need to establish what's what.
