troubleshooting Question

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

Avatar of techman36
techman36 asked on
Web Development Software
2 Comments1 Solution169 ViewsLast Modified:
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?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 2 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 2 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004