Using vfp5...

"product" table
nprodnum: numeric - unique internal product number
cprodname: char - product name

"usage" table
nprodnum: numeric - used to relate to product
.
.
etc

When adding a "usage" record I have a combobox on the form to
select a "product". I have cprodname and nprodnum in the combo
with nprodnum being the bound column. This works great becuase
it stores the product number in usage however I don't like the
fact that the product number displays in the combo.

Is my only choice to do remove nprodnum from the combo, remove
the controlsource and use "replace" based on the selected cprodname?

replace usage.nprodnum with product.nprodnum in usage