Classic ASP Discussion - Multiple update of 2 tables

Print Page | Close Window

Multiple update of 2 tables

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4146
Printed Date: 30 March 2026 at 6:30am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Multiple update of 2 tables

Posted By: ngaisteve1
Subject: Multiple update of 2 tables
Date Posted: 08 July 2003 at 11:35pm

I have 2 tables: stock_issuing and stock_requisition. The screen shot is when I click one of the requester's stock requisition. Here he (bdd_saiful) has 7 requisitions. Currently, how the store admin will do is click the issue hyperlink and type in quantity issued since quantity issued might not be same as quantity requested but after some time I, the web developer, observe that most of the time (95%) the quantity issued is same with quantity requested. So, I thought about make easy for store admin in issuing. When store admin click Issue Selected button, all the quantity issue will be same with quantity requested of the selected record (refer to screen shot).

My problem is, after I click the button, what the process page will do? So far, I managed to get all selected record id only. Hope you guys understand so far. Thanks for all help.

Link - http://www.htmlforums.com/attachment.php?s=&postid=167356 - http://www.htmlforums.com/attachment.php?s=&postid=167356

Replies:

Posted By: Bluefrog
Date Posted: 09 July 2003 at 10:01am

Just add a second link/button/whatever that will pass the right values (same as requested) and process it as normal. Is that it? (Not sure if I understood quire right.)

On the "process page", you could accept a variable called "same" that is either true or false. If it is true, then automatically issue the same amount and if not, prompt for an amount. ???

Posted By: ngaisteve1
Date Posted: 10 July 2003 at 9:57pm

It's ok. I got that fix. Instead of using checkbox, which is more ambitious, I use a hyperlink. I name it quick issue. When user click that link, it will capture it's id and using the id to get the qty_requested and requester and these 2 value copied to stock issue table.