Office中国论坛/Access中国论坛

标题: [求助] : updating problem [打印本页]

作者: netbug 时间: 2003-4-14 04:44
标题: [求助] : updating problem
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编辑过]

作者: harsonliao 时间: 2003-4-14 06:26
提示: 作者被禁止或删除内容自动屏蔽

作者: netbug 时间: 2003-4-14 18:36
标题: Thanks for the idea
thanks again for the idea, harson.
i will have a try .

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)