I am making a DB to register working times and places of staff.
I have some tables of which staff details and worktime registry are relevant for my question.
In a form I fill in the working time, place, date and person. I select the name of the person with a dropdownlist.
When selecting a person with the dropdownlist I want to copy some fields from the person's record in staff details to the new record I am making in worktime registry.
The reson behind this is that some fields in the table staff details may change over time and in my table work time registy I need to save soms fields as they were at that time.
What's the best way to accomplish this in MS access? Do I need to code?
Thank you for helping me out!
I have some tables of which staff details and worktime registry are relevant for my question.
In a form I fill in the working time, place, date and person. I select the name of the person with a dropdownlist.
When selecting a person with the dropdownlist I want to copy some fields from the person's record in staff details to the new record I am making in worktime registry.
The reson behind this is that some fields in the table staff details may change over time and in my table work time registy I need to save soms fields as they were at that time.
What's the best way to accomplish this in MS access? Do I need to code?
Thank you for helping me out!