Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 17th, 2006, 07:41 PM
Registered User
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to dinq11
Default Master Detail Table Prob

hi all

Acctuly i have using Ms sql server 2000 n Vb.net.
ma problem is dat i have a customer invoice. When i save the records it goes in to CustomerInvoiceMaster table and CustomerInvoiceDetail Table. In the form CustomerInvoiceDetail data is entring in a listview(and these r products). When the user Save its invoice the data saved in CustomerInvoiceDetail and it deduct the product Quantity from Stock Table. it going fine no problem till here. When the user enter the customerInvoiceNo which he already saved all the form populated itself. No Heres the problem begins. User Can change the populated data in the list mean the product can be deleted, qty may be changed or so on. Now how i can make a store procedure or write the code in the .net that add back the already qty in the stock table which i deduct When user saved. and add the orignal qty.

plz help me for this.

Regards
Amz Qurashi

Amz D Qurashi





Similar Threads
Thread Thread Starter Forum Replies Last Post
master-detail hhpatek ADO.NET 0 April 3rd, 2008 02:53 PM
Master Detail Records Amsterdaz ASP.NET 2.0 Basics 4 November 10th, 2007 10:58 AM
Master Detail prasanta2expert Access VBA 1 October 1st, 2007 06:37 AM
master detail windows from using C# kamran Yousaf Bk Classic ASP Professional 0 January 12th, 2007 06:39 AM
master/detail beeyule Dreamweaver (all versions) 1 January 18th, 2005 02:59 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.