Two values in drop down list

[Hasse]

Hi,
I have a drop down list that collects information from a SharePoint list.
In this list I have a name column that can contain duplicate values and a
year column. Like this:
NameA 2007
NameA 2008
NameB 2007
NameC 2007
What I'm trying to do do is to show in my drop down list both of these
columns so that every line is unique.
Is this possible to do in InfoPath 2003 SP2?

Regards,
Hans

 

[Andy Bonner]

Hi Hans

I don't know if it's possible in 2003 but I've done it in InfoPath 2007 by
creating a calculated column in my SharePoint list that concatonates 2
columns & then within InfoPath I bind my DropDown to this column. However
in order to bind to the calculated column (they don't show by default), you
have to manually alter the manifest file itself.

 

[Hasse]

Hi Andy,

Thanks for your reply.
If you tell me how to alter the manifest file I will give it a try in IP 2003?

Rehards,
Hans

 

[S.Y.M. Wong-A-Ton]

Have you already seen this article?
http://enterprise-solutions.swits.n...ata-secondary-data-source-xslt&c=infopath2003

To implement the solution, you'll have to know XSLT and how to write code.

 

[Andy Bonner]

Hi Hans

First make a backup of your solution, just in case you screw something up in
your manifest file (been there, done that) ;-}

Within visual studio right click on the manifest.xsf file & select open
with, then select Source Code (Text) Editor.

When the file opens look for the dataObjects node & within there you'll find
a section for your secondary datasource, where you'll see field nodes. All
you need to do is add another field node for your calculated field and away
you go, it'll now be selectable from within InfoPath. Just save the
manifest.xsf file & open it normally.