AnsweredAssumed Answered

Populating fields from all related tables records in found set

Question asked by timothy2k on Jul 7, 2009
Latest reply on Jul 8, 2009 by 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!

 

Outcomes