parent child relation + select sum
i am confronted with following problem 1 ) where to post my question and 2 ) the question itself
1)in vb.net and using an acces database is this the plce to post?
2) i have an acces database which actually a sort of "book keeping"programm
1 master table with the description of the product and 2 child tables one table for the adding to stock and the second for decline the stock the saldo of the two child tables should be the present in stock value.
so i got the whole in one dataset with 3 table adapters ( 1 master and 2 child) on my form1 i can easily slect the master record in a DGview and the link to the cild tables work just fine. Now the actual problem i want to generate an sql statement / tabeladapter and table that give me the sum of the 2 child tables from the selected product: my approach is to add the table to the dataset as step 1 but then i am lost, so secondly i have added the statement as an fillby query to the master table and stuck again.
so how to generate the sum of the 2 cild tables and link that to the product table so that i have a propper parent/child and the sum displayed as i select the record in the master table?
pls i hope that someone has got a very simple answer to this question, as i am fairly new to this all i feel quiet embarresed to ask such an simple thing. should i have attached an xml schema?
By srinivasc_it in forum .NET
Last Post: 08-18-2006, 02:15 PM
By naijacoder in forum ASP.NET
Last Post: 04-27-2006, 12:12 AM
Last Post: 03-21-2006, 09:32 PM
By Nirit Touboul in forum Database
Last Post: 02-25-2001, 12:34 PM
By Bob Hines in forum Database
Last Post: 04-13-2000, 02:53 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL