use a DomainDataSource in multiple comboboxes

See more:

C#

WCF

Silverlight

This is more of a what's the best way question.

I have four combo boxes in an application that are bound to the same lookup table. There are 900 records in the lookup table. Three of the comboboxes are lookups for different fields in my employee table. The last of the four comboboxes is a filter for the employee table. This last combobox can be filtered in a different way from the other three. The list can also be the same as the other three.

What? You may ask. Think of the look up table as a list of stores. So one field is where you buy your clothes, one field is for your shoes and one for your appliances. So the list of stores is always the same but the three data fields can be the same or different.

The application works fine. Currently I have four different classes and four different domain data sources for each of the combo boxes in the application.

I am sure there is a better way than loading the same data four times. Can someone suggest the optimal way to clone or copy the data sources? Do I even need four data sources?

One other important fact. Only one of the three data combo's will always have data. Most of the time the other two could be loaded only if there is data in the field or the dropped event.

Larry Freedman