Multi part forms

[Klutzz]

I have a client complaint form that I want to change over to a web based
entry format. The form is comprised of 4 parts as follows:
1.) client complaint submission
2.) managment reciept, confirmation and routing
3.) internal or departmental review and proposed correction
4.) verification and closeout

I am using FP 2003, on IIS 6.0 with asp activated (have already done a
simpler Dbase with form submission , asp results etc.)

I am confident that I can code the form and set up the database for #1
without any problem. From there I need to be able to be able to pull the data
entered in #1 back up and add to it in step #2 or possibly close it out.
In #3 another user will need to be able to pull up the data and add to the
combined data of #1 and #2 and add to it.
And in #4 Open the record set created in step #3 and add to it .
Finally I need to be able to activly see the staus of completion at each of
the 4 levels.
My best solution so far is to have a results table for each of the 4 data
entry levels that uses droplist query based on the preceding levels results
table and then generate a status level off of each of the results tables.

I am wondering if there is a more compact or streamlined way of doing this.
I am pretty sure I can do this the way I have just described but it seems
like there should be a way of using only one results table and adding to it
but i really dont want to give anyone full access to be able to delete and
modify.
Any suggestions are appreciated.
Thanx,

Klutzz

 

[Kevin Spencer]

If you can program ASP, you can set up 4 ASP page forms. The form handler
for each form is the one after it. The first form posts to the second, the
second to the third, and the third to the fourth. Each form must contain
hidden form fields to store the data from the previous form. The last form
does whatever you want to do with all of the data.

In ASP, there is a Request.Form Collection that contains the names and
values of the form that POSTed to the page. You can get the form values out
of it by using Request.Form("FormFieldname"). From there, you dynamically
add a hidden form field to the form on the current page, using
Response.Write. Example:

<form name=......>
......
<%
For Each FormField inRequest.Form
Response.Write("<input type=""hidden"" name=""" &_
FormField & """ value=""" & Request.Form(FormField) &_
""">" & VbCrLf
Next
%>
</form>

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.

 

[p c]

I have done this. The best way to acomplish it i with code to customize
the process. Here's hoe to do it in concept.

1. Create the table with fields for the complain form, plus the
date/time submitted; plus fields for assigned to, assigned date,
resolution, resolution date, aproved by, approval date, comments, and
whatver else you want to keep with each comlaint record.

2. Create the complain form, e.g/ complainForm.html with forma action to
submit to a processing page, e.g., complainResponse.asp. The processing
page will collect the data fromthe form, validate the information, enter
it in the db, present a confirmation message to the submitter, email a
notice to someone at the "department" for followup with link to a pge
for review, e.g., assignForm.asp?ID=#

3. The review form displays the submitted complaint data plus fields to
assign it to someone for action. It submits to a processing page (e.g.
assignResponse.asp) that adds the info to the DB and emails to the
assigned person with a link.

4. The asigned person in anther form (e.g., resolveForm.asp) and enters
the information about the resolution which submits to a processing page
(e.g., resolveResponse.asp). The procesing page adds info to the DB and
emails the aproval authority for apprvoal.

5. The aprovalautrout reviews another form and approves the action. And
so on.

Depending on the actual work flow, some of the steps can be commbined or
elimanted.

You need to lmaited deltion and posbly nidying to an autraized perosn.
For that, you create a separate admin page.

...PC

 

[Klutzz]

Thanx for the imput gentlemen ! While waiting for a response i decided to
try setting up a droplist query as I saw mentioned elsewhere here and found
that a variation of that is what I need to do. In other words I can set up
one table in the dbase , enter the info for the first form, then for each for
each of the three remaining forms I can recall the previously submitted data
back to thier original locations and add input fields for the new data to be
entered. It makes sense now that I have tinkered with the results wizard a
bit.
Thanx again

Klutzz