import XML Form Into Template
I'm making a project request infopath form that gets filled out by someone and emailed to me. I then fill out how long I think the project will take and I email it to my boss who then either approves it or denies it. When the requestor fills out the form, they have to insert a picture of their signature to the form and then when i fill out my part i insert a picture of my signature into the form. When I hit submit, it sends the form to my boss and also saves a copy of the form to a shared drive. This all works fine but leads to a problem that I can't figure out. When my boss opens the form it goes to a certain view just for him. What I would like to do is put forward and back buttons on this view that lets him go through the various forms that he has yet to approve or deny. I can easily make the button open the XML forms in new infopath applications but what I would really like to do is have him click one of the buttons and have it fill in the current infopath application he has open. That way he doesnt have 30 instances of infopath open open on his computer. My main data connection is a database so its not a problem to use SQL to fill in the data fields like this. The problem is that I cant figure out for the life of me how to extract the pictures of our signatures from the saved forms onto the current form he has open. Surely this has to be possible right? I tried setting up a secondary data connection and then changing the file URL to point to the form where the signatures would be but the data types for the signatures is turned from picture to string in the secondary data source. Any suggestions on how I could get this to work? Thanks in advance for the help.
|