🚀 go-pugleaf

Hi,
How i can do for create an index on 2 filelds of a table; the first fields
is LONG type (userID) and the second fields is CHARATER type (nameID).
This for display in a grid the name of a type of user in alfabetic order in
a ralation 1-N with the table father that contains the various types of
userID.
es.

this.QUERY1 = new QUERY()
   this.QUERY1.parent = this
   with (this.QUERY1)
      left = 19
      top = 0.5
      database = form.database1
      sql = 'select * from "typeusers.dbf"'
      active = true
   endwith

   with (this.QUERY1.rowset)
        indexName = "USERTYPE"
   endwith

   this.QUERY2 = new QUERY()
   this.QUERY2.parent = this
   with (this.QUERY2)
      left = 24
      top = 0.5
      database = form.database1
      sql = 'select * from "users.dbf" '
      active = true
   endwith

   with (this.QUERY2.rowset)
      indexName = "USERID"
      masterRowset = parent.parent.query1.rowset
      masterFields = "USERID"
   endwith

Thank's.
Andrea.