More than 1 invoice

[miltont]

Hi everyone,

I have a report based on job data, but sometimes we have more than 1 invoice for a particular job.

Is there a calculation I could use that would add the invoice numbers together with a comma and a space between,

knowing that the information is coming from seperate rows in a portal?

Any help would be appreciated.

Milton.

[Raybaudi]

Try this calculation in the Job table:

Substitute ( List ( related::invoice number ) ; ¶ ; ", " )

[comment]

See:

http://fmforums.com/forum/topic/77200-getting-to-print-the-portal-along-the-horizontal/page__p__362458#entry362458

[miltont]

Try this calculation in the Job table:

Substitute ( List ( related::invoice number ) ; ¶ ; ", " )

Hi Daniele,

I tried your suggestion but it will not recognise List

I have attached a screenshot of what I typed.

Thanks again.

Milton

[Raybaudi]

I tried your suggestion but it will not recognise List

The new calculation field must be created into the Jobs table, not the Invoices table.

FileMaker recognises List( ) ONLY if you write that function correctly.

Substitute ( List ( Invoices::_id_Invoices ) ; ¶ ; ", " )

isn't the same thing of:

Substitute ( List ; _id_Invoices ; ¶ ; ", " )