I'm working on a projectmanagementsystem for my own company.
Basically there's a database with projects, and there's a database with all tasks performed.
Then there's a database with invoices, and there's a database for the invoicedetails.
When creating the invoice, I'd like to have all tasks for a given project summarized into the projectdetails. For example: there are 5 records "editing" and 3 records "finishing" for a project. In my Invoicedetails-database I'd like to create 1 record with the summarized amount of editing and record with the summarized content of finishing. Off course the terms editing and finishing are variable, it could be named anything...
Any clue what the best scripting-approach would be?