InfoPath Dev

OK, here is the correct way to accomplish this: Add a calculated field, hit the fx button Insert field or group Choose the appropriate data source Expand the list and choose your field Click Filter Data... Click Add Now change the expression so that the item chosen in your drop down matches an item in your ...

Unfortunately I'm on MOSS 2007 so it doesn't sound like Query fields are supported in the way that I need. I'm surprised this type of thing was not supported in InfoPath 2007. Thanks for your input Anson.

Thanks Anson. Are you saying I would have to create a new rule for every "Name" in my SharePoint list?  I'm looking for a way for InfoPath to grab the correct corresponding "Description" once the Name field is selected. Is this not possible?

I have a SharePoint list with two fields - Name and Description. In my form I have a drop down box which is tied to Name. I want another field in the form to auto-complete with the corresponding Description once the Name field is chosen by the user. The ways that I have attempted so far only populate the text box with the first item from the list ...

I am trying to create a very basic form that will be published to SharePoint and will most likely only RECEIVE data from a MSSQL database. Authentication-wise, I would like the querying to be done by a single user, so I will not need to configure a GetUserProfile piece.  Could anyone here point me toward a good resource for getting ...

Thank you for the reply Patrick. I am completely clueless as far as creating a web service goes. At the end of last week I configured Microsoft Single Sign-On on my SharePoint farm. I edited my data connection file as mentioned in the article I linked above. Now I am at least getting an error on my MOSS WFE server. The following query ...

The above error is one I have not been able to get around for over a month now. My situation is:  A MSSQL database loaded on my local machine  MOSS 2007 sp2 server farm with three servers  InfoPath Designer 2010 When I preview the form on my local machine it works. However once published to a SharePoint Form Library, I ...