title: displayvalue, rowsource and rowsourcetype in foxpro 7
body: <p>I have two tables customer and category, to make things simple I'll keep the structure simple :</p>
  
  <pre><code>customer
  ---------
  id            name        categoryid
  ----------------------------------
  1             joe          1
  2             john         2
  
  
  category
  ---------
  categoryid            categoryname        
  -----------------------------------
  1                       User
  2                       Admin
  </code></pre>
  
  <p>I have a form with customer name and some other info as text fields, and a combobox in which i would like to display the corresponding categoryname from category table.
  knowing that i would like the customer table to always store the categoryid, how can i do this with foxpro databinding ? display the category name value, from category table, and store category id in customer table ?</p>