Here is the (simplified) scenario which caused me a problem :
List 1 - "Customers" has
"Customer"
"Address"
List 2 - Orders has
"Order #'",
"oCustomer_lookup" - a lookup field based on the "Customers" list
"oAddress" - a text field which I intend to auto-populate from "Address" in "Customers"
"oCustomer_txt - a text field which i inserted just to demonstrate a point (see below)
Here is the problem:
In InfoPath form for "Orders" I create the data connection to "Customers", and set a "change field" rule for "oCustomer_lookup" with the filter, intending to update "oAddress", but "oAddress" does NOT get populated.
Now I am doing the same for "oCustomer_txt" which I type manually (it is the same result if I use a choice field) and it WORKS like a charm.
What works fine with a text or choice field as a trigger, does NOT work with a lookup field...
A word of wisdom, anybody?