Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / October 2007

Tip: Looking for answers? Try searching our database.

Two values in drop down list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hasse - 21 Sep 2007 09:56 GMT
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 - 21 Sep 2007 23:02 GMT
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.

> Hi,
> I have a drop down list that collects information from a SharePoint list.
[quoted text clipped - 10 lines]
> Regards,
> Hans
Hasse - 24 Oct 2007 20:54 GMT
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

> Hi Hans
>
[quoted text clipped - 18 lines]
> > Regards,
> > Hans
S.Y.M. Wong-A-Ton - 25 Oct 2007 08:48 GMT
Have you already seen this article?
http://enterprise-solutions.swits.net/infopath2003/article.php?t=transform-data-
secondary-data-source-xslt&c=infopath2003


To implement the solution, you'll have to know XSLT and how to write code.
---
S.Y.M. Wong-A-Ton

> Hi Andy,
>
[quoted text clipped - 26 lines]
> > > Regards,
> > > Hans
Andy Bonner - 25 Oct 2007 18:56 GMT
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.

> Hi Andy,
>
[quoted text clipped - 32 lines]
>> > Regards,
>> > Hans
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.