>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.
You may refill the combobox at the point of showing next record ('refresh' point). At that point, you populate the combo with all active record choices, plus one (if it is not active) for this record.
Edward Pikman
Independent Consultant