I need the Process_Number and RecipeNumber keys to be able to receive values that already exist in the table. for example:
Id = 1, Numero_Processo = 1, Numero_Revisao = 1
Id = 2, Numero_Processo = 1, Numero_Revisao = 2
Id = 2, Numero_Processo = 1, Numero_Revisao = 3
or
Id = 4, Numero_Processo = 2, Numero_Revisao = 1
Id = 2, Numero_Processo = 2, Numero_Revisao = 2
Id = 2, Numero_Processo = 2, Numero_Revisao = 3
In both cases I need to repeat the ProcessNumber and RevisionNumber values. These fields are keys in other tables with the Quality_Insp_Inj_Entrance table in the image below.