1 Reply Latest reply on Feb 13, 2020 12:28 PM by Nico Heinze

    Update

    vijay lakshmi New Member

      Dear all,  

       

      I have a requirement to frame the below table.     Table1  --------  Cust Id   Tier     Table 2  ---------  Cust Id | Week1_Tier|Week2_Tier| Week3_Tier...Week54.   

      Every week, the Table 2 must get update on the respective columns from Table1.  If its Week1, Week1_Tier field must get updated.  Week2 , Week2-Tier field must get updated.

         Can you throw some design ideas?        Thanks,  Vj.