Getting a value from a sharepoint list

[Rick King]

I have a secondary data source that pulls all ID's from a sharepoint list.

I can populate an infopath drop down list with all the ID's but i would
prefer to put only the highest ID number from the sharepoint list in a text
box (or expression box) on my infopath form.

can someone show me how i can do this?
Thanks.

 

[steve]

I have a secondary data source that pulls all ID's from a sharepoint list.

I can populate an infopath drop down list with all the ID's but i would
prefer to put only the highest ID number from the sharepoint list in a text
box (or expression box) on my infopath form.

can someone show me how i can do this?
Thanks.

Here's one way....

Add a text box to the form.

Double click the field.

For the Default Value:

Click Fx
Insert Function
Click Math, then Max
Click double click to Insert Field (from the SharePoint List data
connnection)
Choose the appropriate field

Preview the form

should work..

hope that helps....


steve