Summing data across tables

Building

srw     8 months ago

First off, thanks for all your efforts on this project.  I have been evaluating several platforms for a project I am working on and Saltcorn is by far my favorite so far.  One thing that I am struggling with is summing data across tables.  For example, lets say that I have three tables.  The first table contains employee information with a key field being the the employee number.  Another table is a list of project which has a key field of project number.  The third table is a table that contains time spent on projects.  It contains three fields - the time spent, the employee number and the project number.  What I would like to be able to do is create views that summarize in a list the projects and total accumulated time as well as another view with a list of employees and accumlated time.  Is this possible and if so, could you share some instructions?

 

thanks!



No row selected
No row selected
      8 months ago

test comment


No row selected
No row selected
      7 months ago

www


No row selected
No row selected
      7 months ago

wow


No row selected
No row selected
      a month ago

dwqedwewe


No row selected
No row selected
      a month ago

test



Sign up to post a reply