Populating fields from all related tables records in found set
Hi, I have two tables- Estimate and Quote. There are several related quote records for each estimate record.
I am trying to create a script that will loop through and pull a few select fields from each quote record that matches my required Estimate ID# and display them onto the Estimate Layout. Right now it only seems to pull the first record.
Should this be done with variables? Or some kind of loop? Both?
I did not want to create or populate any extra data fields for this if possible, just wanted to display existing fields from the matching record.