Unbound Controls

[Dean Swick]

Fist off I am very new to infopath. I have a VB6 background and know SQL.

I have inherited an infopath project that has some forms that are used to
submit evaluations on employees. The forms are browser enabled and submit
via email.

The HR department wants these to be able query the data. My thougth was to
link as best I could the existing forms to a SQL table.

I am finding that this is not possible so I have built new forms that are
linked to SQL and cut and paste the desgin elements from the old forms.

All is ok so far. Here are my questions:
When the controls like radio buttons and text boxes are cut and paste to the
new form they are unbound. Not a problem because I can just mannually bind
them. However some of the contols on the form do not need to be bound to the
database. They are for view only.

As an example there are 7 radio buttons with a text under them that says:
"Please rate the employee leadership skills". If the rater selectes the
first radio button a 1 should be recorded in the database under leadership
score if the last button were selected a 7 should be recorded in the datbase.

There are also text boxes used to display totals that from there evaluated
areas but not recorded in the database due to the fact that they are
calculated values from other fields on the forms.

Can someone point me in the right direction on this.

 

[Ben Walters]

Hey Dean,
The first issue you have around a scaled rating for leadership skills can be
solved by binding all 7 radio buttons to the one field in the database. From
here you can open the properties for each radio button and set the
"Selected" value to be the associated number required. Depending on which
radio button is selected only the associated value will be stored.

The second issue you've mentioned can be solved with an Expression control
(this may display in the control panel as a "Calculated Value" control

Hope this helps

Cheers
Ben Walters