AnsweredAssumed Answered

Check data in related records

Question asked by willrollo on Mar 13, 2014
Latest reply on Mar 21, 2014 by willrollo


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.