Good afternoon, working on a small data base and I have just extracted the necessary elements to illustrate the question I need help with. In this sample we have two records and each record represents one customer.
Each customer has related records from a table named Open invoices, so each customer has their own set of invoices (see pictures 1 and 2).
I created a button that will trigger a script to send an email to reference all the selected customer's invoice numbers in the subject field of that email. I cannot figure out the syntax needed to specify a calculation that will reference all invoice numbers from the related open invoices table in the email subject field. Any help will be very appreciated!!