E
Emil
I am designing my first form in InfoPath and I need some help.
I want to design a form wich will be sent as attachment to different people.
When they receive the form, and the form is loading, I want to generate the
datasource based on the username of the current user.
What options do I have to acomplish this?
If I use a web service with an parameter, how do i sent the username at
runtime as a parameter to the web service?
My query in the web service looks like this:
string connString = "SELECT tblWELabor.* FROM tblWELabor INNER JOIN
tblProjects ON tblWELabor.ProjectID = dbo.tblProjects.ProjectID WHERE
(tblWELabor.ApprovedPM = 0) AND (tblProjects.ProjMan = '" + ProjMan + "')";
So, basicaly I want to show in the infopath only the rows from tblWELabor
for a certain ProjMan.
I want to design a form wich will be sent as attachment to different people.
When they receive the form, and the form is loading, I want to generate the
datasource based on the username of the current user.
What options do I have to acomplish this?
If I use a web service with an parameter, how do i sent the username at
runtime as a parameter to the web service?
My query in the web service looks like this:
string connString = "SELECT tblWELabor.* FROM tblWELabor INNER JOIN
tblProjects ON tblWELabor.ProjectID = dbo.tblProjects.ProjectID WHERE
(tblWELabor.ApprovedPM = 0) AND (tblProjects.ProjMan = '" + ProjMan + "')";
So, basicaly I want to show in the infopath only the rows from tblWELabor
for a certain ProjMan.