Hello Everyone,

I hope I can explain what I want to do.
On an inventory screen I have a bound combobox on a form which allows the user to select an agreement. There is an active flag in the agreements table, which means some of the agreements are active and some of them are closed. On the inventory screen when adding inventory items only the active agreements should be diaplayed in the combobox so that the user can select one, and in the mean time when viewing older inventory entries with a closed agreement the user should still be able to see the information regarding the closed agreement on the combobox.
I was thinking of setting a filter on the combobox items to just display the active agreements. Or maybe find a way to disable the closed agreements in the combobox.

What will be the best way to do this?

Thank you in advance,
Bianca