Is it an append problem, table problem or am I mad?

[neilmcmor]

I have a form with subform, containing data from 2 tables on a 1 to many relationship. I would like to append the data in the form and subform to 2 seperate tables. The destination tables each have primary keys, (autonumbers) along with the fields I wish to append from the original tables. Can this be done by writing an append query? If so how. I want to append the 2 sets of data and keep the relationship between both sets and this is what is causing problems beacuse the primary keys of the original tables will not be the primary keys of the destination tables and therefore the relationship gets broken. Hope I have explained it ok.

 

[neilmcmor]

I will try to explain a bit better.

Table A contains:- TimetableID (PK), Day, Subject, Teacher, Location.
Table B contains:- StudentTimetableCode (PK Auotnumber), TimetableID, Student.

I would like to append them to:-
Table C:- AttendanceCode (PK Autonumber), Date, Day, Subject, Teacher, Location
Table D:- AttendedStudentTimetableCode (PK Autonumber), AttendanceCode, Student