6 Replies Latest reply: Jan 23, 2014 4:13 AM by Sandeep Subedi RSS

    Create Field in one table By using field in another table.

      I have an inline :

      items id , item descriptions,

      1, Purchase

      2,Sale

      3,etc

      4,Others Reciepts/issues

      5,Other Reciepts/Issues

      6,..

       

      And I also have another table in which i  Got details of quantities.

      where quantities have both Negetive and positive values .

      Now i need

      To Give them quantity details either purchase , or sale or other reciept or issues .But for issues and reciepts, i have to distinguish on the basis of their quantity and id if id is 4 and quantity positive reiciept other wise issues.. please help me. than you.

      Here is the attachment also.

       

      Message was edited by: sandeep subedi