>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
with this
.RowsourceType=6
.Rowsource='table1.descrp,refnum'
.Columncount = 2
.Columnwidths='100,0'
.BoundTo=.t.
.BoundColumn=2
.Controlsource='table2.refnum'
endwith
You could also directly set properties.
Cetin