Hi,
I have a table (alm_hardware) with a field (hardware status) that has the options: "In Use," "In Stock," and "Retired." There's a dependent field, substate, which adjusts based on the value of hardware status. When the hardware status is set to "In Stock," the substate shows "Available" and "New" as choices. When the hardware status is set to "Retired," the substate shows "Disposed" and "Pending Disposal" as options.
Here's the issue: When I save a record with the hardware status as "Retired" and substate as "Disposed," then update the record to change the hardware status to "In Stock" and substate to "New," the form automatically switches the hardware status to "In Use" after saving. This only happens when the hardware status is changed from "Retired" to "In Stock" and the substate is set to "New." However, if I change the hardware status from "Retired" to "In Stock" and select "Available" as the substate, the issue does not occur.
Can anyone help me on this about why it is happening like that?
