Filtering combobox items based on user add, view actions

[phillipi]

VS2005/SQL Server 2005 - I have simple a combobox that is data bound to status lookup table. For the OrderEntry screen where the combobox resides, I can easily filter out the invalid statuses by setting theBindingSource.Filter property. However, since that screen is also used for viewing order records, if I set the BingingSource's Filter property and the order changes its status to one that I filtered out, those records will no longer show when the user attempts to retrieve them.

Any design tips or ideas how I can circumvent that problem... please suggest. The only cumbersome workaround I found so far is to show a text field called status, and another status field combobox with a valid set of items in its dropdown list.

Thanks,
Phillip

[AIS4U]

phillipi:

Double posting threads is not a good idea and is frowned upon.
You have posted this same question in the Database section also.
You should post it to one or the other, but not both.

Thank You