You can get all choices and just use icase(Status='A', desc+' ', '\' + desc) as desc. So, your retired statuses would be shown disabled.
>I have a custom combo class, and I pull my choices into an array property on thar class:
>
>in the init of the class, I have:
>
>select id,desc from choices where status='A' order by id into array this.gadata
>
>also, RowSource=this.gadata, RowSourceType=5 (Array)
>
>It all works fine for entering new data records, but it does not show the match when working on an old record where the Choice has been retired.
>
>
>
>>>How can I set up a combobox so that when adding new records to an input form, it will only display choices which are "active" in the choice table, but when viewing old records in the form, it will need to display the value of the choice, even if that choice is now disabled?
>>>
>>>The fields in the Choices table are:
>>>
>>>status ('A' for Active or 'I' for Inactive)
>>>id
>>>description
>>>
>>>Choices.id is the bound column, and it is bound to an 'id' field in the LineItems table.
>>
>>We're using disabled status for disabled statuses (user can not pick up them). However, we seem to be running into some problems. We have lots of statuses. Having too many disabled statuses in the combo doesn't let IncrementalSearch work properly.
If it's not broken, fix it until it is.
My Blog