I am making a database that tracks each employee's stats
on a daily basis.  The problem I have run into is if an
employee switches managers.  I want the information about
each employee to be viewed under what manager they
currently are under or were under. Here are my tables:
Manager Table
-Manager Badge (Primary Key)
-Manager Name

Associate Table
-Associate Badge (Primary Key)
-Associate Name
-Manager Badge

How do I capture each associates stats under their manager
if their manager changes? Thank You!!