InfoPath Dev

Hi -- sure, if you want item 2 to be filtered by the selection in 1. That is, you have a data source with all the possible option for the list for item 2, and then you only disply the options based on the selection from 1. Search for cascading drop down lists to find more information (here's a blog post by Greg Collins to get you started). If ...

Hi -- that option was new for InfoPath 2007, I'm afraid. You can use XPath to filter and get the same result, but it is a bit more tedious. Here's a blog post by Greg Collins that may help you.

Hi -- I'm not sure I entirely understand what you are asking, but I think after submitting, for a database bound form, the user needs to then query to get back the record. So you'd place some fields (like the date you mention) from the query fields group on your form, let the user enter some information and click a button that queries the ...

Hi -- a lot depends on what event you are programming to. For example, in a Changed event for a field in a repeating group, you can use e.Site (IP 2007). Can you tell us more about what you are trying to do? Are you using InfoPath 2003 or InfoPath 2007? Once you know what row is selected, what do you intend to do? Oh, and there is a Context ...

Hi: You should just be able to use a rule for this. Set a rule on your field with the drop down, DropDownA. The action of the rule should be to set the value of a field, and you want to set the value of TextBoxB. Click the fx button next to the value field. The formula editor opens. Select the Insert a Field or Group button. Select the column ...

I always just check to see if the field is blank. Sure, that won't protect you if something goes wrong when the form is first created, but that's what error handling is for... Don't put any controls on the form that the user can change the info with, just use expression boxes for display. That way another user can't clear something ...

You'll probably find more than one way to do this, it seems to come up pretty often. In general, you could add a secondary data source to your SharePoint library to return the column where you are keeping these numbers, and get the max Id (use a substring-after formula to pull off the CR), add one, and stick the CR and the zeros back on. You ...

Hi: You'll need to filter the data for your @Product_Price field. You should probably use the Filter Data button when you select the @Product_Price field in the formula editor. You want to select the @Product_Price where the Product Name field from your secondary data source is equal to the main data source field that contains the seleted ...

Hi, welcome: As to question 1 -- I don't know of a way around the limitations of filtering in browser forms. I'm sorry. Here is an article on the InfoPath Team Blog for writing a web service to return filtered results. If you don't want to write a web service, we sell a very complete one here. If you aren't a programmer and this ...

Hi, Mark: I didn't want to leave this question as unanswered. As we resolved earlier today, the issue had to do with a rule that was setting the value of the field and some confusion as to what the field's actual value was. Not a SQL issue at all.