Very simple question...i think...Show sharepoint 2007 list data in aninfopath 2003 form

[steve.howlett]

So, I am using InfoPath 2003 & SharePoint 2007...

SharePoint has a custom list with one text field called: "Name" -
there are 3 items: Bob, Sue and Joe...

All I want to do is show via a drop down box in the infopath form:
Bob, Sue and Joe for selection...

I have defined a data connection via Tools - Data Connections - I have
used the data source task pane to drag the data in and used a variety
of controls repeating and non-repeating but the requirement to have 3
names showing in a drop down box has eluded me so far...

I have googled for this on and off for a week - yet nowhere have i
found a tutorial or step by step to do this very simple task...

Does anyone know - step by step please - how to do this? Or have a
link to a tutorial?

This seems like such a basic and easy thing to do - I have got close
but not actually cracked it so i am missing a key step (obviously)


Please help,


Thanks.

 

[darkstar]

1. Insert a Drop-Down List Box
2. Double click on it and select "Look up values in a data connection
to a database, Web service, file, or SharePoint library or list"
3. Select the appropriate Data Connection (or Add if not listed -
wizard will help you connect to your SharePoint list/library and name
your data connection)
4. Click on Select XPath button next to Entries field
5. Expand the myFields>dataFields>[Data connection name] tree
6. Select the appropriate field for your list (if the displayed and
bound values are the same)

You can also filter your list and select different bound and display
fields if necessary.

 

[steve.howlett]

1. Insert a Drop-Down List Box
2. Double click on it and select "Look up values in a data connection
to a database, Web service, file, or SharePoint library or list"
3. Select the appropriate Data Connection (or Add if not listed -
wizard will help you connect to your SharePoint list/library and name
your data connection)
4. Click on Select XPath button next to Entries field
5. Expand the myFields>dataFields>[Data connection name] tree
6. Select the appropriate field for your list (if the displayed and
bound values are the same)

You can also filter your list and select different bound and display
fields if necessary.

So, I am using InfoPath 2003 & SharePoint 2007...

SharePoint has a custom list with one text field called: "Name" -
there are 3 items: Bob, Sue and Joe...

All I want to do is show via a drop down box in the infopath form:
Bob, Sue and Joe for selection...

I have defined a data connection via Tools - Data Connections - I have
used the data source task pane to drag the data in and used a variety
of controls repeating and non-repeating but the requirement to have 3
names showing in a drop down box has eluded me so far...

I have googled for this on and off for a week - yet nowhere have i
found a tutorial or step by step to do this very simple task...

Does anyone know - step by step please - how to do this? Or have a
link to a tutorial?

This seems like such a basic and easy thing to do - I have got close
but not actually cracked it so i am missing a key step (obviously)

Please help,

Thanks.- Hide quoted text -

- Show quoted text -

OMG - that's how you do it!

Thanks so much for your reply - amazingly i spent a few hours looking
at this and googling...

Can you recomend - possibly - any tutorial sites or good infopaht 2003
books? (i am not a programmer)

Thanks again!

 

[darkstar]

Glad to help! I learned a lot from trial and error and Beginning
InfoPath 2003 by F. Scott Barker (Wrox, ISBN 0-7645-7948-7).
I'm not a programmer either, but I know my way around VBA.
Unfortunately, that does me no good in InfoPath, where you need to
know XPath, JScript (or VBScript), or C# (in Visual Studio; the
Express edition doesn't come with InfoPath project templates) to
really harness the full potential of the program.

I usually get answers to questions from the experts at Tek-Tips.com,
but you can get an idea of how little info on InfoPath is out there
(compared to other Office programs) by the fact that it doesn't even
have its own forum (unlike Excel or Access, for example). You can
sometimes get something by using their search engine if you're lucky.

I'm also always on the lookout for really good tutorial or user sites.
Please let us know if you find any.

1. Insert a Drop-Down List Box
2. Double click on it and select "Look up values in a data connection
to a database, Web service, file, or SharePoint library or list"
3. Select the appropriate Data Connection (or Add if not listed -
wizard will help you connect to your SharePoint list/library and name
your data connection)
4. Click on Select XPath button next to Entries field
5. Expand the myFields>dataFields>[Data connection name] tree
6. Select the appropriate field for your list (if the displayed and
bound values are the same)

You can also filter your list and select different bound and display
fields if necessary.

- Show quoted text -

OMG - that's how you do it!

Thanks so much for your reply - amazingly i spent a few hours looking
at this and googling...

Can you recomend - possibly - any tutorial sites or good infopaht 2003
books? (i am not a programmer)

Thanks again!

 

[steve.howlett]

Hi,


Thanks for the book and website info - I am checking them out now....

If I find any good tutorial sites - i'll let you know...

Sounds like there is a gap in the market for some videos on using
InfoPath 2003 and 2007 to be sure...

Glad to help!  I learned a lot from trial and error and Beginning
InfoPath 2003 by F. Scott Barker (Wrox, ISBN 0-7645-7948-7).
I'm not a programmer either, but I know my way around VBA.
Unfortunately, that does me no good in InfoPath, where you need to
know XPath, JScript (or VBScript), or C# (in Visual Studio; the
Express edition doesn't come with InfoPath project templates) to
really harness the full potential of the program.

I usually get answers to questions from the experts at Tek-Tips.com,
but you can get an idea of how little info on InfoPath is out there
(compared to other Office programs) by the fact that it doesn't even
have its own forum (unlike Excel or Access, for example). You can
sometimes get something by using their search engine if you're lucky.

I'm also always on the lookout for really good tutorial or user sites.
Please let us know if you find any.

1. Insert a Drop-Down List Box
2. Double click on it and select "Look up values in a data connection
to a database, Web service, file, or SharePoint library or list"
3. Select the appropriate Data Connection (or Add if not listed -
wizard will help you connect to your SharePoint list/library and name
your data connection)
4. Click on Select XPath button next to Entries field
5. Expand the myFields>dataFields>[Data connection name] tree
6. Select the appropriate field for your list (if the displayed and
bound values are the same)
You can also filter your list and select different bound and display
fields if necessary.
On Mar 10, 8:37 am, "(e-mail address removed)"
So, I am using InfoPath 2003 & SharePoint 2007...
SharePoint has a custom list with one text field called: "Name" -
there are 3 items: Bob, Sue and Joe...
All I want to do is show via a drop down box in the infopath form:
Bob, Sue and Joe for selection...
I have defined a data connection via Tools - Data Connections - I have
used the data source task pane to drag the data in and used a variety
of controls repeating and non-repeating but the requirement to have3
names showing in a drop down box has eluded me so far...
I have googled for this on and off for a week - yet nowhere have i
found a tutorial or step by step to do this very simple task...
Does anyone know - step by step please - how to do this? Or have a
link to a tutorial?
This seems like such a basic and easy thing to do - I have got close
but not actually cracked it so i am missing a key step (obviously)
Please help,
Thanks.- Hide quoted text -
- Show quoted text -

OMG - that's how you do it!

Thanks so much for your reply - amazingly i spent a few hours looking
at this and googling...

Can you recomend - possibly - any tutorial sites or good infopaht 2003
books? (i am not a programmer)

Thanks again!- Hide quoted text -

- Show quoted text -