Avatar of techman36

asked on 

populating fields from current session data and previous session data...a design question

Hi Experts,

I have a website that runs on Coldfusion and uses an Access database. The way it works is that basically there are a series of 5 pages, each is a form that needs to be filled out by the user. Once each form is filled out and the submit button clicked, the page submits the data of the form to the database and then redirects you to the next page/form and so on until all the 5 pages/forms are filled out.

Do to certain reasons we had to design the database so that every time someone logs in, they start a new session and a new record is created. Therefore the same user can have as many records as they have logged into the forms section.

My Question is as follows:

In order for the user to navigate back to the previous page, they can use the browser back button and go back to the previous page where data is read from a record set of that same session and the fields of the form populated with data from that same session. this means that the user can see what they just submitted.

BUT we also want the user to come back later and look at the same form, so this means we want the data to be populated from the session before the current session!

How do I design these forms, so when the user is working on them, it can go back and fort between the individual forms and see data from current session AND have the fields filled out from the previous session's data when the user logs back into the web site after leaving the site?
Web Development Software

Avatar of undefined
Last Comment
Avatar of pinaldave
Flag of India image

you will have to store this sessions in array. when you want to populate them from previous session in that case you do sessionarray[currentsession -1] and you can populate them.
Avatar of DAJED

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Web Development Software
Web Development Software

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo