title: how to retrive data from database and store into textbox in Foxpro 9
body: <p>how do i store the data i get from select statement into textbox.<br/>
  i don't have any idea how to do this because this is my first time using foxpro i need this for my job application pls help me.<br/>
  table name: <strong>emp4win</strong><br/>
  idnum<br/>
  firstname<br/>
  lastname<br/>
  middlename<br/>
  address<br/>
  contact<br/></p>
  
  <pre><code>cm=thisform.cmb1.Text
  SELECT * FROM emp4win WHERE idnum=cm
  </code></pre>
  
  <p>data should be store in the following:<br/></p>
  
  <pre><code>txtfirstname.text
  txtlastname.text
  txtmiddlename.text
  txtaddress.text
  txtaddress.text
  txtcontact.text&lt;br/&gt;
  </code></pre>