Microsoft Access database record

5 pts.
Tags:
Microsoft Access
Microsoft Access database
If I'm updating a person's file, how do I make sure when I update the information about that person, it doesn't automatically update the historical information already associated with that person? For example, I have an instructor who was in grad school, we put his status as "without terminal" and pay him based on his degree status. However, next semester, he is teaching for us again but he has graduated and now has his doctorate degree and he should now be coded as having "terminal" and will then be paid more for teaching? How can I update his file to the new degree and it not remove his original degree status from past records?

Software/Hardware used:
Microsoft Access database

Answer Wiki

Thanks. We'll let you know when a new response is added.

In that case the simplest way would be to have multiple records. Add a column to the table for “active status” and flag it to an “N” when you add a new row. Flag this new row with a “Y”. This way you can keep the historical data for any number of changes. You may also want to consider adding a date/timestamp column as well to keep track of when it occurred. 

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: