InfoPath Dev

Hi,

i have a problem and absolutly no solution.

The scenario:

Table 1: Producer(ID,Name)

Table 2 Product: (ID,Name,REFERENCEtoProducerID)

Now i have a Infopath 2010 Sharepoint Form and wanted to create a Dropdown where the displayvalues are all names of product but with the producername.

e.g.:

#Dropdown#

Producer1 Product 1
Producer1 Product 2
Producer1 Product 3
Producer2 Product 1
Producer3 Product 1
Producer3 Producet2
etc...

 The Problem when i open the settings of the Infopath 2010 Dropdownlist, then there is a Textfield Value and Displayname. and i can't type in ther a formular like "concat(d:Producer,d:Prodct)".
Is there any solution to this ?

Thank you guys =D

Hi-

Modify the SharePoint list to add a calculated column that concatenates the two values, then use that column in your dropdown, as the displayName.

Basically, you have to handle for this in SharePoint, and not in InfoPath. InfoPath can't concatenate the values itself. InfoPath needs to receive the data already concatenated.

Good luck!

 In the Meantime that way my idea , too.

But i can't do a calculated colums based on a reference field:

I created a new colum in the Product table as calculated:

But i could just do this: =ID+NAME

But not = NAME+REFERENCEtoProducerID

Is this normal ?

 I now fixed it with a workflow, which "calculated" the value in a new column. This column i use for the Dropdown.