Error in database updates :The field is updated with the penultimate value

Hello !
I am currently struggling.
I have 2 fields : “Admin status” (relationship from the Status collection to the contract collection) and “client status” (text field in the Contract collection).

Step 1: The admin selects an “Admin status” in the dropdown menu from the Status Collection
Step 2: The admin clicks on “Mettre à jour le contrat” to validate the form
Step 3: The new admin status is updated in the collection
Step 4: A second “record update” is triggered and the “client status” should be updated with the value of the admin status.

However, the admin status is properly updated but the client status is updated late.
For example, I put A as an admin status. Admin status will become A but Client status will not change
Then when I will put B as an admin status. Admin status will become B but the Client status will become A.
Then, again, when I will put C as an admin status. Admin status will become C but the Client status will become B.

Screenshots
STEP 1

STEP 2

STEP 3

STEP 4

Do you have an idea how to proceed?
Thanks in advance for your help ! :slight_smile:

Maéva