Verification of data consistency in 2 different fields:

Summary:

Content (required):

Our customer wants to do a verification of data consistency in 2 different fields: "Grade step name" and "Employee Category". For example, if in the field Grade step, there is a value "Step 1 - Cadre", so in the Employee Category the type "Cadre" should be used. So, for example, if the Grade step is "Step 1 - Cadre" and Employee Category is "Worker" this is not correct.

Our Customer has already a special report to determine the existing discrepancies but this is not enough. They need to do a data validation while entering the data in the system. So, that an error message was appearing if the data is not consistent.