Can you elaborate on "filter it"? Do you mean reset the ItemsSource to a new collection that is built by a LINQ query with a Where clause on the start and term date?

If so, with that approach, I guess my needs could be met with 2 ItemsSources collections that I bounce between based on the mode of the form: ALL items for View Mode, and anotgher collection based on Where Status='Active' for use while in Add Mode.

(In this particular case, the user picks the correct Employee at the time of data entry, and presenting only "Active" employees will properly handle the valid choices. Any subsequent Edits of the data would NOT allow changing the Employee number.)

Anyway, the main point here is confirming that using code-behind calls to reset the ItemsSource to the proper collection set is what you meant.





>Put a start date and a termination date in the employee record.
>
>For display only, the FK relationship will return the correct record. No filter is needed.
>
>When you go to fill the combobox, filter it based on the document date and the start and termination dates.