RR SQL V10

[David_R_(Guest)]

I^m trying to duplicate functionality of a Lookup from RR xBase.__If you have master tableA, detail tableB, and detail tableC. TableB and TableC have multiple records for each TableA record but I only want to Lookup and find only the first record of TableC. Is there a way to do that in RR SQL? I don^t want a record printed in the detail section(from TableB) that^s duplicated for every TableC record.__Thanks.__

[kfleming]

There is not a way in SQL to specify a one to one relation rather than a one to money. But you may be able to get the desired result by using a Group band line rather than a record band. You may need to experiment to find the correct grouping level.____Kathleen__R&R Support