InfoPath Dev

Please refer to attached image file for the form layout and additional perspective on this post.

Scenario:

I have a web-based form that allows for the entry of various members of a groups sport wages . Someone should be able to select a sport and for the particular sport that is selected, select 3 teams from that sport to wage against. Upon selecting a team in any of the three fields, the odds are displayed at the right. So the group manager would input Player 1's 3 teams based on the sport selected for the group and the odds would display successfully for the 3 teams selected. The group manager would then move on to Player 2's selections and the same would follow.

Preconditions:

• Form is connected to a SharePoint list that contains all of the Sport, Team and Odds data 
• The form is a web-based form
• The form has been injected with qRules version 3.1.4101.21572

Issues:

1. The form is setup to utilize the qRules filterowssvr command. A selection in the sport selection field accurately displays the relevant teams in field 1 for player 1. The manager can then choose a team from the available list of selections and the Odds are displayed accurately. However, when the manager moves to the second drop-down to select a second team the only option that is available is the team that was selected in the firrst drop down.
2. If the manager would like to select a different team in drop-down 1 (due to a transcription error, etc.), the manager is unable to do so as the only available options are the previous selection and a blank field. Selecting the blank field does nothing but make that the only available selection in the list
3. there is no way to currently get Player 2 to link to Sport selected and follow the same process independent of Player 1's selections

Comments:

• Should current() be utilized and if so, how would it be used with the filterowssvr command? Examples would be value added.

Thanks for the post. We will investigate tomorrow.

 Has any progress been made on this inquiry? I would like to get an understanding of the issues and potential solutions so this can be deployed.

Has any progress been made on this inquiry. I would like to deploy this as soon as possible.

Sorry for dropping the ball on this. Hilary has offered to investigate. More soon.

Hey there - I'm sorry about the delay!

Can I get a screenshot of your data source that your controls are bound to - or better yet, could you send me your template? I'll email you through the forum so you have my email address.

Your drop down box for Team1-3 and for Team2-3 are not set to use the filter owssvr data source for their entries - is that intentional? Your drop down list boxes are conditionally formatted - any chance that you are looking at the ones that don't use the data source and have no entries hard coded?

Also, can you drag the z:row node from you FilterOwssvr data source onto your form while you preview it - see if the actual available values in your data source are changing? I see no logic that should cause those to change unless the Sport is changed.