Check data in related records
I want to be able to trigger a print script depending on certain data in a related invoice table.
In essence - Customers - invoice details.
I have a field, invoicedetails::date.
From the customers table, I want to be have a dialogue appear with a warning if any of the related invoicedetails:date fields are 14 days or less before the current date.
Not really sure how to go about this - am quite sure it is a simple answer but have brain fog.