Using InfoPath 2010 in Web Forms, I can set a combobox to be populated from a SharePoint list. This part works fine.
Now what I want to do is exclude from the drop-down any matches in the form's submission list. Essentially these are account numbers and I don't want users attempting to submit the form for a given account more than once.
Google indicates that filters don't work on a web-form, and I can't seem to get a filter to work in the InfoPath filler anyways.
I'm trying to figure out if I can get the SharePoint lists like query-able data before it hits the form (so I can basically do
left outer join b where b is null)
So far I haven't found any options like that. Any clues?
It seems almost like Check if task has already been submitted on opening InfoPath task form and switching view to reflect so but instead modifying a drop-down option set (to remove matches from the library).