i need to do something simple.
2 tables
one holds some data include a reference number
the other has reference numbers plus soome descriptive text

i need a combobox on a form (which shows first table's data) to show the descriptive text refered to by the refernce number in the first table. and to be able to choose by the descriptiive text, but store the reference number

the other controls on the form are bound to memory variables of the current record, which are saved by means of add/edit buttons. I also have next previuos buttons on this form.

TIA
Colin