Ok.....I have 3 forms...the first form has a table with Number,Item_Code,Item_Description and opening_balance as its attributes.
The second table has purchase_number,Item_Code,Item_Description,purchase_date and quantity purchased as its attributes and the 3rd table has issue_number,item_code,number_of_issues,issue_date,issue_to_whom,name_of_person, returnable_or_non-returnable ,balance and remarks as its attributes...
the item codes in the 2nd nd 3rd table may be repeated but in the first table the item_codes must be unique...
my job is to calculate the opening_balance in the first table and balance in 3rd table...both are same.
balance is calculated as opening_balance(from 1st table) + quantity_purchased(from 2nd table) - no_of_issue(from 3rd table).
plz help me find a solution for my above problem...
my above mentioned tables along with all necessary database connectivity is done and working.
i just need the solution for calculating my balance...
plz help.
Thank You in advance. :)