I am creating an employee training tracking database. I have all of the training classes in a table along with the number of days said training is valid. (e.g. -[TrainingID],[TrainingName], [ExpirationDays])
I want to be able to have the expiration date automatically calculated when a user enters data into the training transactions table ([EmployeeID] foreign key, [TrainingID] foreign key, [TrainingDate] entered by user, [ExpirationDate] calculated based on [ExpirationDays] where TrainingID = currently entered TrainingID)
It would be best to wrap this logic in a stored procedure, where you pass in the user entered fields, and work out the values for the expiration date.
Something along the lines of
answered Oct 08, 2012 at 08:40 PM
Kev Riley ♦♦