I am working on a project where an engineer completes a certificate document that records the condition of separate components of an air conditioning unit. This includes taking measurements and recording the equipment used to take the measurements of components. These paper documents are then scanned and turned into PDFs.
What I would like to do is create a web/windows form application that allows the engineer to input the data directly. This will save time and once stored electronically the results can be scrutnized more quickly. As well as inputting the data I would like to be able to effectively recreate the certificate document based on the data entered as a pdf.
The problem is there are over 100 certificate documents as there are 100's of components in air conditioning unit and I am looking for advice on how best to acheive this.
For example, should I create a pdf/word template of each certificate document and insert form fields and then do a merge or something similar or should i try and create each pdf dynamically.
I am using .NET and SQLServer or Access Database
Thanks for any help in advance.