Thanks guys...
OK, I'm very new to CF, so I hope this all makes sense. I work for a small company (maybe 100 users) and I'm trying to set-up form where people can submit change requests for our QA documents.
Someone else created the initial form where users can submit the requests and our document control person can then view table in their web browser and see the requests. It works like a simple held desk ticket system. This all works.
What they want me to add is a way to submit files at the same time. This way, users can edit the file(s) in question with their suggested changes for the document control manager to look over.
So, first off, here's the code for the submission page:
[edit] Damn.. I can't seem to get it added correctly. The formatting fubars every time. I'm just going to include the forms in a zip at the end of my post.
Anyway, in the zip is a submission form as described above. This form calls a second form that generates a "Thanks for your submission" page and sends an e-mail to the document control manager notifying them of the request. I've also included this form. The final form is a basic CF upload form.
What I want to do is combine the current submission form with the upload form so that a document can be uploaded to a network directory at the same time the change request is submitted (with a single 'submit'). This way users can edit the document in question and submit their suggested revision. The "thanks" form can remain separate or combined, that's not my main concern since it works as is.
The table where this information is stored already has an unused field named 'docs' where I'd like the location of the uploaded file to be stored (the path). I believe that field was added for this reason at some point, but hasn't been used so far.
Here are the files:
cf forms
