Calculating Total of Values from Related Table
Hello I have 2 tables as below
The relation is made as Table1 >> Table2 where the WP_ID is an auto generated serial which is linked in relation to each other
Now as Table1 is the Main Head table and Table2 is the sub table where all the records are being entered. I want a calculation to be generated where in Table1 I can count the total number of Men, Women, Boys, Girls entered in a month.
I am abit confused but I know someone is out there to help me out in this regard, Thanks in advance.
Why do you have separate fields in Table2 for men, women, Girls and boys? If you put the data for all four categories into 4 separate records with a field that identifies the category, getting the needed totals becomes a lot simpler.