Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PROBLEM: impossible to use lookup relations on grid
Message
 
 
To
17/09/2003 12:24:49
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00829957
Message ID:
00830185
Views:
20
Fabio,

>i use a relation for lookup text values on a cursor and put text on a grid.

Grids are just not designed to work with two cursors as you are trying to do.

>
>	ADD OBJECT grid1 AS grid WITH ;
>		RecordSource = "CA", ;
>		Column1.ControlSource = "CA.id", ;
>		Column2.ControlSource = "CB.Txt", ;
>
> than is hard to found a workaroud.

There are several ways to solve your problem.

1) pull down a denormalized cursor that contains your looked up value.

2) run a SELECT once the data is in VFP to a denormalized cursor

3) put your lookup data into an array property of a combobox, that is bound to the PK value from CA and use that as the control in the second column of the grid.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform