Calculating on Records II
Here, we add the "Orders" Table
Now, the "Clients" and "Product" Tables are related, through the "Orders" Table .
Now, we finish filling the properties of the Query in the grid by adding the field "Totals" in the "In Stock" field and the "Client's First Name" and "Client's Last Name" fields, just like we did in the previous topic.
But this time, we will use the "Sum" option for "In Stock", and we will apply "Group By"the "Client's First Name" and "Client's Last Name" fields
The result of the Query will be: