2 Replies Latest reply on Jul 8, 2009 8:43 AM by timothy2k

    Populating fields from all related tables records in found set

    timothy2k

      Title

      Populating fields from all related tables records in found set

      Post

      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.

       

      Thanks!