Avoiding COPY PASTE
I'm a novice with a challange.
After using FM Go I found a script using COPY PASTE (worked fine for years) which copied a Trailing Grand Summary field from Invoices Table and PASTED to Contacts Table did not work. My script basically finds all Invoices with a balance due > 0 then totals all found records. Copies the result and Pastes to Contacts table field. I have tried to use a relationship but the field I want to use is grayed out.
Is there any way to do this without COPY PASTE?