12 Replies Latest reply on Nov 7, 2015 3:15 PM by wimdecorte

    Use execute SQL to update related fields


      I often use triggers on fields to update sort fields in related tables. For example; I will have a CONTACTS & INVOICES table and have the name field in both tables. Yes, they are related by CONTACTS Primary Key; but I would have that name field in Invoice table for sorting in a list for performance reasons. So if someone updates the name field in CONTACTS; then I will update name in related Invoices with a looping script or sometimes Replace Field Contents.

      Is there a way to do this without go to layout, find ID, Loop? I was wondering if I can set the field via current context with execute sql?