Summing data across tables

Building

No row selected
No row selected
srw     2 years 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
      2 years ago

test comment


No row selected
No row selected
      2 years ago

www


No row selected
No row selected
      2 years ago

wow


No row selected
No row selected
      a year ago

dwqedwewe


No row selected
No row selected
      a year ago

test


No row selected
No row selected
      9 months ago

eddd



Sign up to post a reply