aanshi

Omit records in relationship

Discussion created by aanshi on Jun 15, 2016
Latest reply on Jun 15, 2016 by coherentkris

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 ?

Outcomes