Address etc would like file upload label and control added newclient

My queries and what I would like you to fix are below… I want the same layout kept as close to what it is as possible. The only real changes I want are listed below.

1)

I would like the Database/Tables and Webform code normalized correctly so I can update, delete, email etc correctly which updates, deletes or alters the database correctly in a normalised way.

My current attempt works, but it is not normalized correctly so in effect it is useless for my project.

4)

When I add a Client to the system, in the NewClient.aspx webform there is a print button, when I press this I want a word document to opened up which will have the ClientName, address1, address2, address3, County, country, email, Department, CasePlan, Description, Fee and Feeduedate populate on the word document. I want to them be able to edit the word document so I can add or delete content from. I Want to be able to use this as a letter that I can post to the client.

c) List of cases by department per month (include all tables, name, address etc)

d) List of case plans per month (include all tables, name, address etc)

6)

I would like a file upload label and control added to NewClient.aspx, UpdateClient.aspx and EmailSolBarCase.aspx webforms. This should be uploadable to the database LynnLawManagement in the ClientDetails table and downloadable so I can email to the solicitor/barrister in EmailSolBarCase.aspx webform.

Thank you,

Bren

lynnlawsolicitor2@gmail.com

lynnlawbarrister1@gmail.com