DropDown populated by secondary data source contained in a repeating table to be filtered by previou

[jsl]

I have a dropdown populated by a secondary datasource in a repeating table.
As the user adds rows to the table i would like the dropdown list to be
filtered to not include previous dropdown(i.e. itself in previous rows)
selections. As an example

a repeating section contians a drop down for PlayersName. The drop down is
populated from an external datasource with ten players names. The repeating
section allows players to be selected. However, a Player can not be
selected twice.

Any Ideas? We've tried filtering but either end up with an empty dropdown
or one that always allows for the selection twice. Might just be xpath
challanged but sure tried several(ok more then several) permutations.

 

[Franck Dauché]

Have you tried by code (such as c#) behind?

Regards,

Franck Dauché

 

[jsl]

We are using c# code behinds in many cases. However we were hoping to
accomplish this via the filter and associated xpath. Has anyone done this
before?

 

[S.Y.M. Wong-A-Ton]

Yes. You need to use not() when filtering the entries for the dropdown list
and while comparing the items of the secondary data source with the field
representing the dropdown on your InfoPath form.

If you are still having problems getting it to work, post the XPath
expression you've generated for the "Entries" field, along with the setting
for the "Value" field, and I'll try to help you out.

Regards,
S.Y.M. Wong-A-Ton

 

[S.Y.M. Wong-A-Ton]

I've implemented a similar solution with rules and filters, and posted it here:
http://enterprise-solutions.swits.net/infopath/shrinking-dropdown-list-repeating-table.htm