I've hit a wall on this problem, perhaps one of you can point me in the right direction. I have a form that shows data from multilple tables. I want all the data visible to be saved as one new record in another table to make an historical record of the forms. How should I approach this? Yes, I'm kinda new at this.
Maybe a little more background would help. I am creating an employee records database. Currently, people are filling out time sheets on a paper form. I have created an Access form using the paper form as a background image so it looks familiar to people. The user will select an employee and all the basic information (name, social security number, regular schedule, etc.) will appear superimposed in the right places to fill out the form. The user will then type in any overtime taken, sick leave taken etc. into boxes to complete the form. So far, so good.
The problem is, I want all that data on the form that comes from several tables and user input to be saved as one record in a new table that will form an historical record of time sheets. I dont want the information saved in that table to update as employee records change. If someone has their work schedule changed, the old timesheets should still show the schedule they had at the time the timesheet was created.