🚀 go-pugleaf

I have changed this to a datamodule and now the data will show correctly for
the first rowset when I open the form.  The problem is that the form's
navigation changes the fulfillment rowset in the grid. I only want the grid
items displayed.

When the customer rowset is changed I want the corresponding info displayed
for the fulfillment info in the grid.

Can anyone help please.

Here is what I've created:

class EntriesDataModule of DATAMODULE


   this.SESSIONTLC = new SESSION()
   this.SESSIONTLC.parent = this
   with (this.SESSIONTLC)
      left = 1
      top = -0.0455
      lockRetryInterval = 0
   endwith


   this.DBTLC = new DATABASE()
   this.DBTLC.parent = this
   with (this.DBTLC)
      left = 7
      top = -0.0455
      databaseName = "TLC"
      session = form.SESSIONTLC
      active = true
   endwith


   this.CUSTOMER1 = new QUERY()
   this.CUSTOMER1.parent = this
   with (this.CUSTOMER1)
      left = 3
      top = 2.5
      database = form.dbtlc
      sql = "@Customer.sql"
      active = true
   endwith


   with (this.CUSTOMER1.rowset)

      indexName = "CUSTOMER ID"
   endwith


   this.FULFILLMENT1 = new QUERY()
   this.FULFILLMENT1.parent = this
   with (this.FULFILLMENT1)
      left = 9
      top = 2.5
      database = form.dbtlc
      sql = "@Fulfillment.sql"
      active = true
   endwith


   with (this.FULFILLMENT1.rowset)

      indexName = "CUSTOMER ID"
      masterRowset = parent.parent.customer1.rowset
      masterFields = "Customer ID"
   endwith

endclass