Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Multiple update of 2 tables
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Multiple update of 2 tables

 Post Reply Post Reply
Author
ngaisteve1 View Drop Down
Groupie
Groupie
Avatar

Joined: 26 December 2002
Location: Malaysia
Status: Offline
Points: 169
Post Options Post Options   Thanks (0) Thanks(0)   Quote ngaisteve1 Quote  Post ReplyReply Direct Link To This Post Topic: Multiple update of 2 tables
    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

Back to Top
Bluefrog View Drop Down
Senior Member
Senior Member


Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bluefrog Quote  Post ReplyReply Direct Link To This Post 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. ???

Back to Top
ngaisteve1 View Drop Down
Groupie
Groupie
Avatar

Joined: 26 December 2002
Location: Malaysia
Status: Offline
Points: 169
Post Options Post Options   Thanks (0) Thanks(0)   Quote ngaisteve1 Quote  Post ReplyReply Direct Link To This Post 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.

Edited by ngaisteve1
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.