Good morning Glenn (here afternoon US+7 hrs:)
Right at least 3 ways and actually I myself use the 3rd - RowsourceType = 3 SQL :)
Cetin
>Good morning (evening) Celtin,
>
>I find it interesting and rewarding that in VFP there are always many ways to solve a problem. I did not see your response as I was writing mine, and after seeing yours I commented to my self "of course it can be done that way too!"
>
>VFP is an amazing tool with an extremely rich language,
>
>Glenn
>
>>>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