How to get a field with multiple values onto an invoice
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!
FMP 10 Mac 10.6.2