Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lookup Combo in Grid
Message
From
05/07/2006 07:01:32
 
 
To
05/07/2006 06:47:36
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01133757
Message ID:
01133765
Views:
20
OK. I've just checked what I did in a very similar situation. I have an extra column to take the description field.
In the interactivechange() of the combo I have:
With This.Parent.Parent.Column3.Text1  && where column3 is the text field to hold the desc
  .Value		= This.List( This.ListIndex, 2)
  .Refresh()
EndWith
Can't remember the reasons. I did want to show both the code AND the description in the grid. Maybe I came up against the same problem

>Terry
>
>>Does it help if you set BoundTo = .T. ?
>
>No the result is the same
>
>Luigi
>
>>Terry
>
>>Hi at all,
>>
>>I have the following situation
>>
>>Table name.dbf
>>Code c(4)
>>Description c(20)
>>
>>Table data.dbf
>>xxxx c(2)
>>yyyy c(2)
>>Code c(4)
>>
>>
>>I have a grid for table data.dbf and in the column of Code I have insert a combo with following settings:
>>
>>BoundColumn = 2
>>ColumnCount = 2
>>ColumnWidths = 75,0
>>ControlSource = table.code
>>RowSourceType = 6-Fields
>>RowSource = name.descritpion,code
>>Style = 2 - Dropdown List
>>
>>It works fine if I set the Sparse setting of column = .f. but I want to have the combo visible only if the customer click in row, this works if I set the sparse setting to .t. but the value displayed in column is obviusly the code and not the descriprtion is there any solution or idea for this situation.
>>
>>Thank you in dvance for any help.
>>
>>regards
>>Luigi
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform