I'am making a medical databases.
The database is needing another table in MS access to set it to history of all patients.
Once i edit the existing record its history will be recorded and should be save in the history table in MS access and the the new that is being replace to the old record will be recorded in the Main MS access.
how can i made it?

Plz help me.. It will helps me a lots.
Thankz.