🚀 go-pugleaf

>I tried reversing the master detail
>relationship but that only returns the first record.

Here follows another untested solution, if you care to try it out:

class PROCSDataModule of DATAMODULE

   this.PROCS1 = new QUERY()
   this.PROCS1.parent = this
   with (this.PROCS1)
      left = 10.4286
      top = 0.4091
      sql = 'select * from "PROCS.DBF"'
      active = true
   endwith

   with (this.PROCS1.rowset)
      canGetRow = class::PROCS_CANGETROW

   endwith

   this.CLAIMS1 = new QUERY()
   this.CLAIMS1.parent = this
   with (this.CLAIMS1)
      left = 2.8571
      top = 0.5909
      sql = 'select * from "claims.dbf"'
      active = true
   endwith

   with (this.CLAIMS1.rowset)

      indexName = "CLAIMNO"
      masterRowset = parent.parent.procs1.rowset
      masterFields = "CLAIMNO"
   endwith

   this.CLAIMS2 = new QUERY()
   this.CLAIMS2.parent = this
   with (this.CLAIMS2)
      left = 2.8571
      top = 0.5909
      sql = 'select * from "claims.dbf"'
      active = true
   endwith


   with (this.CLAIMS2.rowset)

      indexName = "CLAIMNO"
   endwith

   this.rowset = this.procs1.rowset

   function Procs_canGetRow
      local bCanGetRow, oRS
      oRS = this.parent.parent.claims2.rowset
      oRS.findKey(this.fields["CLAIMNO"].value)
      bCanGetRow = not oRS.fields["CLOSED"].value 
      if bCangetRow
         bCanGetRow = this.fields["TOS"].value = 'X'
      endif
      return bCanGetRow

endclass
__
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://lonestar.texas.net/~moursund/
Try these help resources:
http://forumsearch.borland.com:88
http://www.dejanews.com/home_ps.shtml