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?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros