1.In a form I have a master block which has details like bill_id,maintainence_center_name,shipper_name,reason an many other things.
2.In the same form I have a detail block for the the above mentioned details which has details of materials that are to be shipped
i.e material_code,description,part_n,quanity and many other details.
3. In the detail block i have given aroud 5 records that can be entered by the user.
4.The problem is with the update.
5.How can I update the quanity of the various material_code in the single maintainence center with a single update button.
example
1.In abha 10 materials are present with matcode ='9149022'
SQL> select count(abha) from tbs where matcode ='9149022';
COUNT(ABHA)
----------
10
2.In abha 9 materials are present with matcode='7211482'
SQL> select count(abha) from tbs where matcode ='7211482';
COUNT(ABHA)
----------
9
Now in my detail block i select 2 items from the matcode 9149022 and 4 items from the matcode '7211482'
If it was single matcode with in the maintainence center the update would have been easy
BUT
how can i update the multiple items with different matcodes with in the specified center..?
Edited by: Suhail Faraaz on Nov 22, 2010 10:57 PM