Infopath pulling values from SharePoint list

[PeteM]

Hi Guys,

I've got a form which pulls values from a SharePoint list.

My Sharepoint List:
Value 1 | Value 2
Name | 3

I select Value 1 in a Drop Down list, which then populates a Text Box with
the matching Value 2.
I also have conditional formatting in Infopath set on those Value 2 Fields
to change the value to Red Bold text when I change the value from the
default. (Ie, in this instance I want the Value of Name to be 5 instead of
3)

My problem is that when I close and re-open the form, the value
re-calculates back to the value pulled from SharePoint.
If I take off the option on the Data Connector to not recalculate the fields
when the form is opened, none of the values populate and I end up with a
blank field.
I've got the Form Options enabled to store / cache the data indefinitely in
the form
The Fields themselves are set to re-calculate when the formula changes.
Unchecking this gives no results at all.

Any ideas how to get it to retain the data in my form, but remember the
values I set?

 

[Shiva]

Hello,

1. You have to add the rule on dropdown selection value. Depends on
selection value you set the corresponding value to text box.
2. You want to do some calculation to change Value 2 data on above rule.
3. If your dropdown point to main DOM then those values should save into
that form. If you reopen the form also dropdown values should not refresh.