Answer to Question #49555 in C# for ramy

Question

i am new in programming .. so i facing a problem , i am coding a program for a clothing shop .my problem in the sales returns .. discussing the problem in an example . first in my database i have 3 tables : salesorder, salesReturns,ledgeraccount .in the example i made a sales order with 3 items every item with 100 l.e. so the total order with 300 l.e. .the next day the customer want to returns one item from the 3 items .. so i will open the sales order and return it so easily . my problem after that .. i returned 1 item so the sales order with 2 items only .. but if i opened the sales order again i will find the 3 items