Hello,
I've been reading up on this for quite some time and cannot manage to grasp this. I'm about 80% sure that I can accomplish this through InfoPath, however I cannot seem to get it finished.
I'm attempting to utilize InfoPath 2010 as a dashboard to populate data from a SharePoint 2010 list:
The user has multiple filters to go through prior to pulling displaying the data. You would first choose which office you're in; All Sites, Personal Lines, or Safeco. Then decide whether or not this is an Auto or Property. I think I have figured out how to accomplish this, using Picture Buttons and on click changing the view. The view would switch all controls to the specified field of choice. This works fine. If you can think of a better way to accomplish this, let me know.
What I'm having difficulties with is when the user selects a state, I want the list box/text box (where enter choice is currently sitting) to display the necessary information within the Value field of this SharePoint list:
The lookup lists are comprised of these lists, which are obvious what they include. Each one has a lookup of the field prior to associate the specific items in each list to the specified office.
I cannot seem to get this! If anyone can help, I would greatly appreciate it!