1 Reply Latest reply on Jun 15, 2016 5:04 AM by coherentkris

    Omit records in relationship

    aanshi

      I have two tables Client and order.

       

      Client Table

       

      Client IDTotal Orders
      A101
      A102
      A103

       

      Order Table

       

      OrderID
      Client IDStatus
      2001A101Confirm
      2002A101Cancelled
      2003A102Confirm

       

      In client table,there is one field Total Order.I want to store confirm order in this fields.

       

      A101 - 1

      A102 - 1

       

      How to discard cancelled records using relationship ?