title: MS Access tracking effective dates of employees
body: <p>I currently have an MS Access application that stores information about the employees who have responsibility for a certain task.</p>
  
  <p>My form goes like this. You enter the task in a textbox. You pick the employee from a combo box which is bound to the staff table. And finally we save this information to the Task table. As simple as that I thought...</p>
  
  <p>But here is the problem. No employee works forever in a company. A new/another employee maybe assigned the task which was previously carried out by an employee who is no longer working there. In the form once I update the new employee the old employee information is replaced and we wouldn't even know that that employee existed.</p>
  
  <p>I came across the concept of adding effective dates to the employee which may be used to track the history of employees.</p>
  
  <p><strong>Now I would like to know how I would be able to preserve the data of the previous employee when I update the Task form with the information of the new employee.</strong></p>
  
  <p>What should I do?</p>
  
  <p>Thank you for your assistance.</p>
  
  <p>BR,
  Paul</p>
  
  <p>I have uploaded links to three forms that I am working on. </p>
  
  <p><img src="https://i.stack.imgur.com/lwQmo.png" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/rfdyN.jpg" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/dCHLT.jpg" alt="enter image description here"></p>
  
  <ul>
  <li>In the outside company officer form we don't have the date fields mentioned.</li>
  <li>In our companies proposal form we might need to add additional officers but don't want to repeat the proposal information just the officer, division, alternate officer &amp; division.</li>
  <li>In the outside company detail form we might need to apply the same concept to the director of the company without applying to other institute information.</li>
  </ul>
  
  <p>I was also researching on this topic where I found a document which explains the concept of effective dates. I need to know how to apply this and also without making a lot of changes to the application.</p>
  
  <ul>
  <li>www.gsa.gov/graphics/staffoffices/DatedInformationandDateTracking.pdf</li>
  </ul>
  
  <p>I hope this helps you understand my problem.</p>