I have a DB that was recreated by somelse which needs to be normalised correctly.

The purpose of the DB is know how many of each Dept Forms Numbers have been sent out to clients via mail between a certain period.
e.g so betweem 01/07/03 and 30/09/03, there were so many of each form number Number that we sent of clients.

The current stucture is a follows

tblClientCaller
ClientID
LastName
GivenName
Address
Form1 (e.g M36a Assurance of support application)
Form2 (e.g M37b Assurance Support explanatory Notes)
Form3
DateSent

tblForms
FormID
FormNumber
FormName

Now I want create an additional table to store the forms that were sent out by an operator. If im correct, this should the right way of contructing it. This would allow user to use a subform to enter the forms that a client has requested.

Im I correct in contructing my table in this way.

tblClientCaller
ClientID
LastName
GivenName
Address etc

tblClientCallerForms
CallerFormsID
ClientID
FormsID
DateSent

tblForms
FormID
FormNumber
FormName


Now, theres over 1000 client records using the non nornalised db. How can I copy the data e.g form1 form2 form 3 into tblClientCallerForms so that each form requested becomes its own new record in many table and is linked back to the client.

Do I need to use some link of append query and how wouldI do that?