Query forms as submitted without resetting the fields.

[sboyd]

I have a form that is used to submit information to a database. I
want to query the records that haven't been imported. The imported
field is a y/n field. I want the form to retrieve the records just as
submitted. When I add the query field import and run the query, it
pulls the records that haven't been submitted but it resets all of the
data that is on the form; therefore, only a small portion of the
original information is displayed on the returned set of forms.

How can I query up the records and display the views just as they were
submitted? I want to use this as an edit so changes can be made and
resubmitted back to the database?

 

[Clay Fox]

Are you using the same form to view the data?

The Query will return all of the fields from the database as they are
currently saved. Possibly your form has fields which are not in the database
that you want to see.
To see these as they were then you would need to save a copy of the form as
well as submitting to the database. This could be done manually or by adding
a submit to a file share or Sharepoint.

You may want to check out the Database Accelerator web service suite from
http://www.qdabra.com. It has version history where you can go back and see
each update to a particular document, if that is what you are looking for.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com