I am using a Winform. If I understand things right I can create a new field
in one table of a dataset and get the aggreate value of a field in another
table of the dataset that is related.
To test this I have a form with the orders and order_details tables of the
NorthWind Database of SQL Server 2000. In the .xsd file called DataSet1.xsd
I added a new row to the Orders table. The E field = element, the field to
the right of it equals TotQuant and the field to the right of that equals
Int. This table is related to the Order_Details table with a relation name
DrMain.
In the expression of the new element I wrote the following
Sum(child(drMain).UnitPrice). When I run the form I see the new field in the
orders table called TotQuant but it equals Null.
Is it possible to do what I want? If so, what is the method?