AnsweredAssumed Answered

How to get a field with multiple values onto an invoice

Question asked by carolynhaywood on Mar 7, 2010
Latest reply on Mar 7, 2010 by carolynhaywood

Title

How to get a field with multiple values onto an invoice

Post

I'm trying to make an invoice.

 

I have a layout called Billable Time (based on Table Billable Time related to Table Invoices via InvoiceID) where different levels of professionals enter their time for each job.  Not all levels are present on every job.

 

I need a way to show only the levels used on the job on the invoice.

 

I tried a calculation field in the Invoice Table  (I.e. If level = "Consultant"; "Consultant") which works fine for the first level but apparently it only works for the first level entered as none of the other levels show up.

 

I tried a look up field in the Invoice Table which didn't work at all.

 

Any suggestions would be greatly appreciated!

 

Thanks,

Carolyn Haywood

Beginner

FMP 10 Mac 10.6.2

Outcomes