title: Using field not displayed in list for subsequent search
body: <p>I am using wx.ListCtrl to display the results of a database query. If the User then selects an Item I want to use a non-displayed field (Client.idClient) to query another table and display the result (can only be one row). The query and 'core' of the display are:-</p>
  
  <pre><code>sql = "SELECT Client.idClient, Client.LastName, Client.FirstName, \
          MedicalCondition FROM Client INNER JOIN MedicalCondition \
          ON Client.idClient =  MedicalCondition.idClient \
          ORDER BY Client.LastName ASC, Client.FirstName ASC, MedicalCondition
  
  try:    
        cursor.execute(sql)       
  except ValueError:
        print "Error: unable to read data"
        print("Error:", ValueError)
  
  rows = cursor.fetchall()
  
  self.listCtrl.InsertColumn(0, 'Last Name', width = 175)
  self.listCtrl.InsertColumn(1, 'First Name', width = 150)
  self.listCtrl.InsertColumn(2, 'Condition', width=175)
  
   #print 'Done headings'
  
   n=0
  
   for r in rows:
         self.listCtrl.InsertStringItem(n, r[1])
         self.listCtrl.SetStringItem(n, 1, r[2])
         self.listCtrl.SetStringItem(n, 2, r[3])
         n+=1
  </code></pre>
  
  <p>My question is how can I capture Client.idClient for the subsequent search. Creating a  hidden array to hold the data seems inefficient and could potentially become quite complex as features such as paging and scrolling are added.</p>
  
  <p>Thanks in advance...</p>