General

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

york31 — Thu, 09 Jan 2014 09:04:16 GMT

This solves it.

Thanks!

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

donstephen — Thu, 09 Jan 2014 07:53:05 GMT

Thank you for the additional information. It seems that No_lookup is not returning the correct value. May I know what type of InfoPath control the No_lookup field is? If this is a drop-down control, you may want to check the Value and the Display name by right clicking the field's properties.

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

donstephen — Thu, 09 Jan 2014 07:52:56 GMT

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

york31 — Thu, 09 Jan 2014 07:41:49 GMT

Thx for the fast response.

I am not sure how I can send you a sample, but here is a simplified example that can be created in 5 minutes.

Create a list named "Projects" with 2 fields, both of type "Single line of text":

"Title",
"Project_no"

Populate it with two entries:

{"Project A", "111"},
{"Project B", "222"}

Create a list named "Orders" with 3 fileds:

"Project Title" (single line of text),
"No_txt" (single line of text),
"No_lookup" (lookup of "Project_no" in the already created "Projects" list)

Create an InfoPath form for "Orders"
Try to populate"Project Title" with "Title" from the "Projects" list, whenever "No_txt" changes (e.g. type "111" manually) - it works!
Try the same for a change in No_lookup" - it does not work for me.

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

donstephen — Thu, 09 Jan 2014 04:26:17 GMT

Hi york31,

I'm not sure yet how your form is set up, but are you pertaining to a person/group picker (people control)?, if not may I have a sample of the filter value for the lookup field? Since you were able to query using a different field, then the only problem I'm thinking of is the filter query value you are using.

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

york31 — Wed, 08 Jan 2014 14:10:55 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 widom, anybody?