InfoPath Dev

What you want is to add a calculated value control and enter a formula that calculates the maximum value in the Bid column in your sharepoint list, filtered to include only Bids for the current Item (I'm assuming that you also have an Item column in your list that is used to distinguish between different items).  That formula ...

Here's an idea: switch to a new view where a link is displayed and instruct the user to click that link.  You will design the link as a Hyperlink control, and its default value will contain the URL to the page you are designing and a formula to append the query parameters.  For example, if your base page is ...

 My guess is that all three entries are displayed as text boxes because when you close and reopen the form you lose the connection to your secondary datasource.  Secondary data sources are not persisted when a form is closed, which means that if you're not re-querying the data source when the form is reopened you will lose the ...

 Hi Frankie, What exactly do you mean by "task pane"? Are you creating a custom view in your InfoPath form?

 Hi Jürgen, When you say "The Access rights to the library are okay" that, to me, implies that your users belong to a particular SharePoint or Active Directory group that has special permissions set for your library. What are the permissions you've assigned to that group?

 What version of InfoPath and SharePoint are you using? Is this a browser-based form?  InfoPath will automatically detect the username of the person who has opened the form, and depending on your answers to my two questions above there are different ways to detect the full name of the user and then record that name in the form when ...

For Rule2, you want to set Field 3 equal to Column C in the SharePoint list with the following filter on C: Column B is equal to Field 1.

 Hi Bruce,  What I'd suggest instead is creating a Web Part page on SharePoint.  You can then embed your InfoPath form in this page and configure it so that when anyone opens up this page, a new blank form will automatically be displayed.  That way, you can put a link to this page on, say, your homepage and say ...

 Hi Drew,  There are two options for running a workflow automatically: run when created, and run when changed.  What about deselecting the "run when created" option? That way the workflow would only run on existing items, which is what you want. Does that make sense?

 Hello from The USA!  What you need is a new True/False Boolean field in the form. For the purposes of my explanation, let's call this field Locked.  The default value for Locked should be FALSE.  Now, add a rule to your Submit button that sets Locked to TRUE when the button is clicked (i.e. no ...