auditing table??

[spinkung]

hey,

i'm building a simple skills database which records the skills of individuals in my company based on the departments required tasks.

I'm trying to encorparate a way of recording historic data so i can report on individual improvements over time when it comes to reporting later on.

Whats the best way to have a historic scoring table in my db??

I have 3 tables for the scoring as follows

Employee (payroll, fname, lname) --> Emp_Scores (payroll, task_ID, score) <-- Tasks (task_ID, task_name)

...where would i put the audit?? in the Emp_Scores table or create a new one?? If i create a new one what is it joined to??

Thanks,
Spin.

 

[JamesMcS]

Yeah, probably best to have a new table. Join by employee ID. You can have empID, skill/task, and date. Then, if it was me, I'd have an event on a form somewhere (say a button) to run a bit of SQL, appending to the audit table.