Hi,
I have a field named Sequence number in a table named Table A. There's another table named Table B where these two tables are linked with a relation
TableA.QualityOrderNo == TableB.QualityOrderId
TableA.SequenceNum == TableB.SequenceNum
There's a field named Result in Table B.
Now, the condition is, when I change the sequence number in Table A which has certain value linked to results in Table B, should retain its Results value whenever I change its sequence number
For example, consider a test case where I have a sequence number = 10 and this has the value in Results field as 100.
When I change its sequence number to 20, the value in the test case should retain but instead its creating a new test case without any value in the Results field.
Now, I should write the code where I can update the existing Results to the test case which has new sequence number now.
