Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto Complete in a Grid
Message
From
12/10/2000 08:06:46
 
 
To
12/10/2000 02:44:17
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00428354
Message ID:
00428392
Views:
27
Hi, Jeremy!

You do not need to upgrade, the problem seems not in that. See notes below.

>I need the 'Description' field to show rather than the key field.
>
>i.e.
>
>SrchTable (This is the Table that contains the items)
>Item_ID Item_Desc ........
>1 Description A
>2 Description B
>3 Description C
>
>GridTable (This is the table shown in the Grid)
>Detail_ID Item_ID ..........
>1 2
>2 2
>3 3

Be sure, the problem is not in your search control. The problem is that grid column with your control shows incorrect field. You need to set grid.column.ControlSource to the MyTable.Item_Desc field. Remember that grid columns should always be bound to data field. Sometimes grid 'reset' bound fields, so you need to set up them again programmatically (this is not fixed in VFP6). Probably you doing in your code something like 'Grid.RecordSource = "something"'. This cause contro sources to shuffle to match order of fields in record source. After this command you need to set up control sources again programmatically.

HTH.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Reply
Map
View

Click here to load this message in the networking platform