maya
|
Posted: 10/30/2003, 10:04 PM |
|
Any Help Please
I have a very long survey form (3 sections)and I want the user to be able to enter information (section 1) then save; continue to fill out form (save section 2) then to continue to fill out form then (save) Submit.
Environment Windows 98, MS Access, win2000
Product CodeCharge Studio 1.0.7
Programming Language ASP/VBScript w/Templates
|
|
|
ryan
|
Posted: 10/31/2003, 3:26 PM |
|
Maya,
U'r question is similar to the one I previously posted. It's not an easy task though but....here's a guide (of course this is not the best solution but works good enough for me :)
Determine the form elemens/database fields to be saved on each sections!!!
basically I can visualize ur Survey table as 'something' like
Survey
--------------
ID----Survey----Desc---fld1---fld2---fld3----item1----item2----item3
1-----hello-----hello--1------2------3-------i1-------i2-------i3
2-----hello-----hello--4------5------6-------i4-------i5-------i6
3-----hello-----hello--7------8------9-------i7-------i8-------i9
4-----hello-----hello--10-----11-----12------i10------i11------i12
5-----hello-----hello--13-----14-----15------i14------i15------i16
6-----hello-----hello--16-----17-----18------i16------i17-------i18
The working algo I think would be
----------
Section 1
----------
Survey--------Desc------
'save these fields temporarily before going to Section 2
----------
Section 2
----------
fld1----------fld2------fld3
'save Section 1 & Section 2 fields temporarily before going to Section 3
'if user hits back, must be able to do update on Section 1
'if user cancels then don't proceed saving
----------
Section 3
----------
item1---------item2-----item3
'save Section 1 & Section 2 fields temporarily before hitting the final Submit
'if user hits back, must be able to do update on Section 1 & Section 2
'if user cancels then don't proceed saving
'if final Submit button is clicked save all fields (section 1, 2, 3)
I hope this will be a (not good enough) idea, now apply it...it's tedious though to save 255 fields you can either break down your tables to one is to one relationship (more db tables) or this would open your analytical mind to something more efficient :)
|
|
|
|