One of my tables has a column Reporter_Name with Reset On Edit turned on and an initial value expression like:
Where ReporterInfo_fk is an Enum type column with Ref sub type. When selecting a choice in ReporterInfo_fk during a new form entry, Reporter_Name changes as expected. However, if I clear the choice in ReporterInfo_fk, it also clears the value in Reporter_Name.
Is this standard behavior? If this is standard behavior can I change anything in my expression to retain the value already in the column if I clear ReporterInfo_fk?