I have had situations where SQL Select isn't what I want so another choice is in a one to many situation you select the "many" table and relate it to the "one" table by the common key. Then "report form myreport for one.idref = value".
>I have a report that pulls data from several tables. There is one table that will have numerous records that needs to printed for the specific ldref#. How do I go about printing all of the records....an array of information.