How to disable a value from an enum (so canno't be selected anymore) BUT not remove it (so old records and reports are still valids) ?

Hello,

I wonder if one of you has a good solution on how to disable a value from an enum (so canno't be selected anymore) BUT not remove it (so old records and reports are still valids) ?

For instance, a enum field with 4 values

  • A
  • B
  • C
  • D

Let's suppose that A what an option that was valid for old record but no more for new ones. Is there a proper way to remove this option when you create or update a record, but that will keep this old values for searches, reports etc.

Currently, without dev (that is an option) we

  • has a enum field : A, B, C, D
  • has another field enum field :version : V1, V2, V3 ...
  • the first enum field as a visibilty dependency according to the second one
  • the second one is set a default value for any new record so it will trigger the correct visibilty ; so any new version, you need to set up the default value correctly
  • of course we need an initial setup for all records

So it's a bit anoying and not really

any better idea or suggestion is welcome.

Regards,

Fred