InfoPath Dev

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

 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 ?

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 ...