Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox to show descriptive text
Message
From
24/04/2002 07:49:29
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
24/04/2002 06:48:50
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00648550
Message ID:
00648567
Views:
20
>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
*Combo init
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform