I have a requirement to make logic when suppose I have a table with different columns as:

Hi ,

I have a requirement to make logic when suppose I have a table with different columns as:

A, B, C, D and here there are 5 version for each row example:

V1 has A1,B1,C1,D1

V2has A2,B2,C2,D2 and so on till V5

Now what is need to be done is when user is updating v1 version then he is allowed to update only D1  and once he update D1 column as 2 then future version of

D2, D3, D4, D5 will only update as 2 when A1+B1+C1 combination contains exact value and if any of the version does not contains the combination of A+B+C then value of D as 2 will not update for that version

example:

V1:  A1=cat  B1=dog C1=bat D1=1

V2: A2=cat B2=dog C2=bat D2 = 2

while updating D1 = 5 ( V1: A1=cat B1=dog C1=bat D1=5)

then value changes for V2 (future version only if a1 b1 and c1 is identical as a2 b2 c2):

V2: A2=cat B2=dog C2=bat D2= 5

Mike Schmitt