I have a client that has a lengthy form and would like the ability to start the form, submit the data, then come back later and finish it. Or submit all the data and come back later and edit some information that may have changed. Example: Trip Registration form that asks for number of trip participants or number of meals needed. A month from now we may have added participants which would also increase the number of meals needed.
So, I am trying to create a form that allows me to submit form data and later go back and have that data pre-fill the form. I know how to create the form and enable fields to be populated dynamically. However, I do not know how to retrieve the form data that is already stored in the database and display it.
So really I have 2 questions:
1. Is there a way to retrieve form data already stored in the database and display it in the form fields to be edited by a user?
2. If so, how exactly is the data structured in the database?
Thanks for all your help,