I have browser forms published to moss form library, upon opening the form, it will run a query first to retrieve data from
database(query here just overrides the infopath native query),
however, when the form is loaded with the retrieved data, i found some of the fields are locked(not sure with it but according
to my observation, those fields with no data loaded are locked). The only fields I can edit are those populated.
To make it more clear, the form has several views, one login view, one default view, one readonly view (created from default view) ,
when user logs in successfully, rules are applied to run the query before default view is displayed.
I test it in both browser and client and both get the problem.
can anyone help with this problem?
much much appreciation for any help, suggestion.