Auto-populate a lookup value based on another lookup field does not work

york31 — Wed, 08 Jan 2014 14:11:03 GMT

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?

General

Auto-populate a lookup value based on another lookup field does not work