Merge fields to a new table

[Tweeytlab]

Hi there,

I have a table which lists activities such as:

12/07/07 Admin 10.00

12/07/07 Onsite 20.00

15/07/07 Admin 5.00

15/07/07 Onsite 30.00

15/07/07 Admin 6.00

I need to combine (and total) the records on the same day to an invoice table. For example:

12/07/07 Admin; Onsite 30.00

15/07/07 Admin; Onsite; Admin 41.00

I have a parent table listing jobs, so these entries would be under a parent "job number".

I am hoping that someone can point me in the right direction of creating a script which can do this.

Thanks!

[tv_kid]

To get a total for the day, create a relationship based on the date, and then a calculation field totaling the hours from the related records. See attached file for an example. The file includes a custom function to get the description as you've requested, but this may not be necessary depending on your setup.

HTH

Jobs.fp7.zip