complete save and display routines for a dot.net module

Need completion of a document scanning module. The scanning procedure itself is already taken care of, but we want to finish the saving routine that saves the info regarding the document scanned. The module is written in vb.net and is given 4 arguments when it is called by the parent program. The arguments are: CustomerNumber long Lastname text field Firstname textfield Companyname textfield The screen needs to have some additional fields added and the overall size of the form needs to be expanded to at least twice its current size. The form itself needs to display who’s information is being saved. That means there needs to be a label on the top of the form that reads: Saving documents for: Cust# [12345] Johnny Walker The first field beneath that should be “Descriptive document name:?? This would be a field where the user can input a name like: “Johnny’s return slips?? or “letter thanking company?? Read more in the complete description and please read attached files. ## Deliverables Need completion of a document scanning module. The scanning procedure itself is already taken care of, but we want to finish the saving routine that saves the info regarding the document. The module is written in vb.net and is given 4 arguments when it is called by the parent program. The arguments are: CustomerNumber long Lastname text field Firstname textfield Companyname textfield The screen needs to have some additional fields added and the overall size of the form needs to be expanded to at least twice its current size. The form itself needs to display who’s information is being saved. That means there needs to be a label on the top of the form that reads: Saving documents for: Cust# [12345] Johnny Walker The first field beneath that should be “Descriptive document name:?? This would be a field where the user can input a name like: “Johnny’s return slips?? or “letter thanking company?? We also need a combo box that would show the various types of documents that they might be saving. These various types would be listed in the doctype table (which you need to create along with a small form to allow the user to add new document types into the table (DocTypes) We also need another combo box where the user can pick the priority value of the document. (A number 1-5 [5 being the most important]) Then we need a description field that can take up to 255 characters - needs to be larger than what is already on the existing form. We need a date field where the user can input the actual date of the document . The scan datetime would be taken when the document was originally scanned. Next we need a small grid where the user can add his keywords to associate with this document. Each keyword or keyword phrase would be saved as a single record that links back to the record that saved the document descriptive data. It would link back by saving the parentrecid - which is the original recid of the record describing the document. We have discussed the save routine but we also need a method to retrieve the documents in a fashion that allows the user to see the snippet of info that they saved about the document and a thumbnail of the actual document. We can use an intenet browser object for this or a grid that can display both graphics and text on a row. I am okay with using flash objects to display the graphics and the associated descriptive text. The naming of a saved document would follow these rules. You would concatenate the following info into a filename that consist of the following elements separated by a “-“ (a dash) First would be the customernumber then the actual datetime value and finally the company followed by the proper file extension for that type of file. (PDF, TXT, DOC, etc). Custnumber ??" datetime ??"[login to view URL] of file it is The module users should be able to display a list or screen of all documents that are associated with a customer. And they should also show all documents that are retrieved because of a search on keywords. When searched by keywords we should also show the results by date and/or priority. That is basically what we need to do to finish this module. Picture of current HORRIBLE form for this purpose: As you can see many of the fields are missing and there are no search buttons, combo boxes etc. They did complete the scanning portion of the program.. Table layouts - you would need to create these three tables - we will be using msSQL here but you can use mysql if you prefer for creation purposes. Design for tables to save data for scanned documents DocumentInfo DocTypes DocKeywords Recid = autonumber RecID = autonumber ParentRecID long CustomerID = long DocumentType text 50 (letter, complaint, bill, invoice, return receipt) Keyword = text 100 Lastname = text RecID = autonumber FirstName = text DocType = long DocName = text DocDescript = text 254 DocPriority integer (1-5) DocDate = datefield ScanDate = datefield DocSize = long Company = textfield Path2Doc = textfield Making the file and path name Custnumber ??" datetime ??"[login to view URL] of file it is