1 2 Previous Next 15 Replies Latest reply on Mar 7, 2010 6:14 PM by carolynhaywood

    How to get a field with multiple values onto an invoice

    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

        1 2 Previous Next