SharePoint List Items integration Question

[JustinDevine]

Hello,

I am completely new to InfoPath, however I have a large amount of
experience with SharePoint. My goal is to use Infopath to create a
"sign-up sheet" for events stored in a SharePoint Events List. I am
really having difficulty. I never though it would be so difficult to
work with complete SharePoint list items but it appears that InfoPath
OOTB functionality is limited to working with SharePoint Data one
field(column) at a time. My goal was to create a dropdown that
contained used a SharePoint list as a data source and contained each
SharePoint Event Title ("Event" Column) and its Date ("Begin"
Column). Is this really that difficult or am I missing something?
Can someone give me some advice on this. I think I will somehow have
to perform a function that concatenates "Event" and "Begin" for each
sharepoint list item. and populates a dropdown with this. I have a
bad feeling I am going to end up in "script.js"

:-(

This is Infopath 2003 btw. 2007 is coming but not soon enough for
this solution.

-Justin

thanks in advance

 

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

That's correct: You can only show one field at a time in a drop-down list
box. You are dead on about what you'll have to do to enable your scenario. I
did something similar in this article:
http://enterprise-solutions.swits.n...ata-secondary-data-source-xslt&c=infopath2003