Hi,
Brand new to Infopath. Am using 2003.
I am looking at building a help desk request form... here is what I have achieved so far...
Created a new form. On the form are 2 dropdown lists that are populated from sharepoint (MOSS 2007) lists.
I have published the new form to a forms library on MOSS.
I have created a web service (vb.net) that takes the form values and puts them into a SQL (2005) database.
Now I want to add code to the webservice so that it emails the help desk to let them know a job has been submitted.
I have no problem creating this code but what I'd like to do would be to have a second form where the help desk would assign a technician and add any comments.
The email from the web service would contain a link to this second form and the second form would be pre-populated with info submitted with the first form.
Is this possible with infopath? Up till now I've been using an email (xml attached) behaviour when submitting the form.
Obviously I'd need to refer to some unique ID I create when inserting the data from the first form... but can I populate fields on form2 based on a SELECT behind form2?
In a web page scenario it would simply be code behind. Something like txtname.value = mydatareader("name")
Hopefully you cann understand what I'm trying to achieve here.
Many thanks
Jay