I'm working in FMPro 12 Starter Solution 'INVOICES'.
I need to correlate and calculate information from a number of purchases on an invoice. For example, say there are a total of 6 items listed on the invoice: A,B,C,D,E and F. How do I fish out products 'B' and 'E' and enter their corresponding field data into another field for calculation or look-up? Products B and E might be of the same category or product type, but each requires the print out of a different result. Also, products B and E would need a sub-total $ result/summary.
Any help with this greatly appreciated.