>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

Set

with this
  .Columns=2
  .Columnwidths=xxx,0
  .BoundColumn=2
  .BoundTo=.t.
  .Controlsource=SecondTable.ReferenceNumber
endwith

Load the list like this:

with this
  .clear()
  select firsttable
  scan
    .additem(descriptivetext)
    .addlistitem(ReferenceNumber,this.newindex)
  endscan
endwith

Glenn