Concat secondary values

[Jürgen Dietze]

Infopüath 2007

Hello together,
i have the following problem:

In a secondary dataconnection I get the fields "LastName" and "FirstName" of
our employees.

I want the user to choose his name from a dropdownlist, displayed in this way:
"Lastname, FirstName"

There is no chance for me to create such a field in the database, so I have
to use the infopath-fields.

Can anybody tell me, how i can do this?

Thanks a lot
Jürgen Dietze

 

[Shiva]

Hello,

You have to add one more field to store last name and first name values in
that field. You can bind this new field to dropdown list to display those
values.

 

[Jürgen Dietze]

Hi,
i tried to do this but it doesn't work: i just get the first entry of my
secondary datasource. Here ist the datasatructure:

Employees
myFields
datafields
Employees (as repeated group)
First_Name (textfield)
LastName (textfield)

I added a repeated textfield with the following value:
concat (@lastname; ", ";@firstname) => received just the first entry

I added repeating group "persons" with non repeating field "completename"
=> same result

What do I have to do to get all the entries into my primary field?

Regards
Jürgen