In the first part of our InfoPath 2003 form we ask the user to select his department. Once chosen the form has to load and show a second selection box in which the user can select half finished forms from only his department that are stored into our database. To do so we need a way to modify the SQL select statement based on the earlier selected department.
Is it possible, as it is in ASP and ASP.net, to query a database using variables that are loaded with values within the form?
It if so what is the syntax to call a variable in the SQL statement?
We don't use codesigning and work in infopath 2003