[求助] : updating problem

netbug

could some1 give me some idea on this problem .. i had been seek for the forum, but really no idea . thanks at 1st

table 1 : order info.
  [U]ID        OrderQty    TotalSendQty[/U]
    1            100
    2            300

table 2 : send info.
   [U]TransID     ID     SendQty[/U]
         1          1        10
         2          1        50
         3          2        100
         4          1         20

i create a form for table 2 , as frmSend , how do i update the TotalSendQty ( in table1) while i adding a record in frmSend ?  ex.  ID 1 , TotalSendQty= 80

thanks for help again :>

[此贴子已经被作者于2003-4-13 20:44:50编辑过]

netbug

thanks again for the idea, harson.
i will have a try .