I have created a data connection to a MSSQL server. When the form, which is browser-compatible, is opened, the user's name is obtaining from active directory. The form is supposed to retrieve the user's department and division based on the email of the user, which is compared in the data connection. Everything works in InfoPath; however, when I publish the form, then open the form in the browser, the department and division fields are not populated. Would this be a permission issue? How can I get this to work?
TIA.
Mike