1 Reply Latest reply on Jul 29, 2013 7:14 AM by philmodjunk

    Calculating Total of Values from Related Table

    ShaikhAtta

      Title

      Calculating Total of Values from Related Table

      Post

           Hello I have 2 tables as below

             
      •           Table1           
                         
        •                     WP_ID
        •                
        •                     Month
        •                
        •                     Year
        •           
             
      •      
      •           Table2           
                         
        •                     WP_ID
        •                
        •                      Men
        •                
        •                     Women
        •                
        •                     Girls
        •                
        •                     Boys
        •           
             

            

           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.