I posted a question yesterday asking how to write data from a Sharepoint list into an Infopath form. The help I received was spot-on and I am most grateful. Unfortunately, I didn't think far enough ahead when I asked. Here is what I am trying to do. I have two fields (amongst several others) on an Infopath form: Supervisor Status and Corporate Status. This form is an accident report that requires two-stage approval. I want to open my new form from Sharepoint and have these two fields be blank. Workflow requests supervisor approval. Supervisor responds with Accept or Reject. If I open the Infopath form up at this stage, the status should be reflected in the corresponding field. Repeat for Corporate Approval. Workflow completes.
Basically, I want the form to be able to be opened at any stage and have it show current and correct status. So far, I can't make this happen. With yesterday's help, I get data on the form but it doesn't seem to be specific to the document. Any ideas?