Tracking Changes to fields
I have 3 tables A, B, and C...
Table B has 2 foriegn keys one for table A and one for table C.
Table C lists the people, table B assets, and A lists the projects
When I assign the asset(s) to the person and project "works great" can see this in my dasboard. However, I now want to track and view the changes i.e. I assign assets to a new person, or new project, or new person and new project etc. What is the best method to accomplish this?