I have a projects table which is 1 to M to the stage gates table. I am creating a chart in the child table to portray how many projects will be available for approval in what months. To do so I need a project count. I can summarise from a child table but not the other way round. Any idea how to achieve this?
You could set up Statistics table with one record (Record ID#1) then make that the parent of Projects. The Related Statistic field in the Projects table will be 1 (also the default value). You can then summarize all the Projects as a whole or specific conditions in Summary fields (on the Statistics table) to then bring down as a lookup field down to the Projects table then again down to the Stages table. This should get the '# of Projects' you are looking for.