I would like some general help with my tables. I'm trying to design a reports database for work. You see the problem is i made a look up table with employee details that can add the details of staff involved with a particular incident. If a person is involved in report #1 but then gets a change of job title a week later, I want to update is details for new reports but if I call up report #1 again I would wish to see his old job title. Does this mean i would have to have two seperate entries for the same person or maybe another table?
Hope this makes sense as I am totally new to this.