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
Form1 (e.g M36a Assurance of support application)
Form2 (e.g M37b Assurance Support explanatory Notes)
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.
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?