CREATE TRIGGER UPDATELINK FOR POS_SALES AFTER UPDATE POSITION 0 as
begin
  Update Pos_salesDtl Dtl set
  Dtl.sdtl_Sales_OPERID =
  (Select Sales.Sales_OPERID from Pos_Sales Sales Where
  Sales.Sales_Store = dtl.Sdtl_Store
  and Sales.Sales_Ctrno  = dtl.Sdtl_CtrNo
  and Sales.Sales_Transno  = dtl.Sdtl_TransNo )
,
  Dtl.sdtl_Sales_DateTime =
  (Select Sales.Sales_DateTime  from Pos_Sales Sales Where
  Sales.Sales_Store = dtl.Sdtl_Store
  and  Sales.Sales_Ctrno  = dtl.Sdtl_CtrNo
  and Sales.Sales_Transno  = dtl.Sdtl_TransNo  )
,
  Dtl.sdtl_Sales_RcptNo =
  (Select Sales.Sales_RcptNo from Pos_Sales Sales Where
  Sales.Sales_Store = dtl.Sdtl_Store
  and  Sales.Sales_Ctrno  = dtl.Sdtl_CtrNo
  and Sales.Sales_Transno  = dtl.Sdtl_TransNo  )
,
  Dtl.sdtl_Sales_SuspendDate =
  (Select Sales.Sales_SuspendDate from Pos_Sales Sales Where
  Sales.Sales_Store = dtl.Sdtl_Store
  and  Sales.Sales_Ctrno  = dtl.Sdtl_CtrNo
  and Sales.Sales_Transno  = dtl.Sdtl_TransNo  )
,
  Dtl.sdtl_Sales_Shift =
  (Select Sales.Sales_Shift from Pos_Sales Sales Where
  Sales.Sales_Store = dtl.Sdtl_Store
  and  Sales.Sales_Ctrno  = dtl.Sdtl_CtrNo
  and Sales.Sales_Transno  = dtl.Sdtl_TransNo  )
,
  Dtl.sdtl_Sales_CustomerID =
  (Select Sales.Sales_CustomerID from Pos_Sales Sales Where 
  Sales.Sales_Store = dtl.Sdtl_Store 
  and Sales.Sales_Ctrno  = dtl.Sdtl_CtrNo
  and Sales.Sales_Transno  = dtl.Sdtl_TransNo )
,
  Dtl.sdtl_Sales_PriceLvl = 
  (Select Sales.Sales_PriceLvl from Pos_Sales Sales Where 
  Sales.Sales_Store = dtl.Sdtl_Store 
  and Sales.Sales_Ctrno  = dtl.Sdtl_CtrNo
  and Sales.Sales_Transno  = dtl.Sdtl_TransNo )
;




  Update Pos_Payment Pymt set
  Pymt.pymt_Sales_DateTime = 
  (Select Sales.Sales_DateTime from Pos_Sales Sales Where 
  Sales.Sales_Store = Pymt.Pymt_Store 
  and  Sales.Sales_Ctrno  = Pymt.Pymt_CtrNo
  and Sales.Sales_Transno  = Pymt.Pymt_TransNo
   ) 
,
  Pymt.pymt_Sales_SuspendDate = 
  (Select Sales.Sales_SuspendDate from Pos_Sales Sales Where 
  Sales.Sales_Store = Pymt.Pymt_Store 
  and Sales.Sales_Ctrno  = Pymt.Pymt_CtrNo
  and Sales.Sales_Transno  = Pymt.Pymt_TransNo )
,
  Pymt.pymt_Sales_CustomerID = 
  (Select Sales.Sales_CustomerID from Pos_Sales Sales Where 
  Sales.Sales_Store = Pymt.Pymt_Store 
  and Sales.Sales_Ctrno  = Pymt.Pymt_CtrNo
  and Sales.Sales_Transno  = Pymt.Pymt_TransNo )
,
  Pymt.pymt_Sales_PriceLvl = 
  (Select Sales.Sales_PriceLvl from Pos_Sales Sales Where 
  Sales.Sales_Store = Pymt.Pymt_Store 
  and Sales.Sales_Ctrno  = Pymt.Pymt_CtrNo
  and Sales.Sales_Transno  = Pymt.Pymt_TransNo )
;
end