So, is there a way to so this in C#?

Thanks for the code. I suppose that I can add some code in the event handler for BeforeSave the check if they are trying to select an inactive item if they are in edit mode. Or is there a better place to check?

Marcia,

Yes you can do that and since you have a LookupBO instance in the form, this will have all the data in the combo and you can navigate that BO to locate the one selected in the combobox.

Also if you prefer to handle this at the BO level, you can turn on the BO's Property Accessing/Changing/Changed events, and then trap the changes there:

Edhy Rijo

Marcia & Edhy,



I got to thinking about this and ended up doing a little sample app to see if what I was thinking would work. Using this along with some of the ideas Edhy has provided might end up with a sweet solution.



Basically, I broke the issue into two parts:



1. Modify the display if items based on their status (active/inactive)

2. Only allow selection based on status.



The key to 1. is to setup the combo to be owner drawn, then draw the items based on status.



The key to 2. is to check the items selected in the SelectedIndexChanged property (or it might work better to use the property events Edhy mentioned) and if the item isn't active, chance the selection. I used an internal property to track the last item that was successfully selected to get this done. Note that this worked best if the combo had a top most item setup.



I personally like the idea of removing items during edits...but it would likely only be during Adds, because during an edit if an inactive item is already selected, you couldn't remove it (easily anyway).



See the sample for details.



Hope this helps!

Hi Greg,

Thanks for this sample.  I think this kind of implementation is more for a subclassed combobox due to all the code needed to make it work.  I do like your approach, even though I think I would prefer to show only active items during adding.  At the beginning I was thinking on using the BO.Filter to accomplish this in a less invasive way.

Edhy Rijo

Hi Edhy,



I agree that a subclass would be a good way to go. I just wanted to do a proof of concept, to show how it could work. Another way to do it would be to make a component that has this code. Then you could just add the component to a form were you needed it, set a combo property and you're good to go. Thus you could add this to existing combos without having to change them. However, it could get complicated as you'd need to generalize how to determine active/inactive (or whatever state that is needed) based on an arbitrary BO(s) and field(s). I'd probably wait until I'd done this a couple of times before attempting that.



I'm not sure how much I like this approach (disabling selection, changing display of active/inactive items), myself (just wondered how it could be done). Showing only those valid items when adding seems like a good approach, as it doesn't confuse the user with old data. However, it gets complicated during edits, as you need the inactive values in the combo because they might already be assigned, but you don't want the user to be able to change to another inactive value. It also could be confusing that the user can't select some values. I'd probably provide an optional message indicating why they can't select an inactive item. I also noticed that the font/style of the text of the combo isn't affected by DrawItem. I'd probably also handle setting the font if the combo based on if the item is active or inactive.



In any case, lots of ideas on how to get this done at least!

Hi all,

I don't know if this helps but if you are using the Infragistics controls you can easily change the row colour for inactive records.

Initially, we only showed active items in our lists but we found this resulted in a number of support calls complaining that our application was failing to show apparently valid records, etc. Given the nature of our support contracts this resulted in someone remoting into the customers system only to find the record was inactive all the time. By color coding the record the user has a visible indication and you can trap the event even if the user attempts to select an inactive record (with SF I guess you could use broken rules). For some lists we have several different colours, i.e. a customer could be inactive or temporarily onhold due to payment problems with a different colour for each condition.

Showing all records but informing the user that some are inactive with a different colour has cut down on wasted support calls when the user can't see the record and doesn't think of checking if it is inactive.

Just my two cents worth

Hi Aaron,

That is also a good idea and the way VFP combo works as Marcia was requesting, by disable the item.

I also found color coding on listviews come out pretty good, but only if you are consistent with all color coding used in the application.

Edhy Rijo