InfoPath Dev

Hey guys,  I have a dropdown in my form that is fed from a SP list and contains several hundred records.  What I would like to do is allow the user to select a filter: A-I, J-R, S-Z, and 0-9 and have the value of that selection be an expression that can be used to filter the main dropdown.  Is it possible to set the filter to ...

OK, I answered my own question.  I followed the steps here to create a repeating table, and then specified the default values for each Category up front to initially build my table.  I added a Y/N field to conditionally display each section of the repeating table and it works like a charm.  Went from 192 fields (12 fields X 16 ...

Sorry if there is a fairly easy answer to this that I'm not seeing, but I wanted to get the best practice for what I'm trying to do. I have a form that lists several categories in sections on the view.  Each section will be hidden and potentially displayed based on the value selected in another control.  Each of the categories ...

Thanks Anson.  I actually tried the concatenated column in SP at the very beginning, but unfortunately InfoPath (using 2007) will not pull in calculated list columns, at least from my experience.  If there is no other way, I may just go the code route to accomplish what I need.

Hey guys,  I haven't been able to find any good answers for my questions, so hopefully someone can help. Question 1:  I have a form with a data connection that pulls 2 columns from a SP list: Code and Statement.  I have a Multiple Selection List Box that uses this data source.  What I would like to do is concatenate ...