Avatar

Level 2

I'm desiging an interactive Preformance assessment review form that will be put on a sharepoint site. Here's what it will ultimately have to do:

A user will open the form template and based on an ID field retrieve info from a database to populate fields in the page headers. It will be partially filled out. When submitted it has to write some data back to the database and save a new document back to a different sharepoint site.

Then the user's supervisor has to review the form, fill in one set of ratings and save it back to sharepoint. The user has to review and sign the form. The supervisor has to sign it and save it back to sharepoint. Then a reviewer has to sign it, save it and the rating has to go back to the database. Once completed the signed form will be used 6 months later to do a final rating and the whole process repeats. Once finalized it will be imaged and removed from sharepoint for the next cycle (yearly).

So far all that I have read in the forums indicate that the PDF doesn't play well with sharepoint. This form will be used by about 40,000 employees so adding a DSN to 40,000 PC's is going to be a problem. I know there is a way to glean the data out for the database but my main concern is the check out/in so it can be reviewed and filled out.

Comments, suggestions, ideas?