Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids with data from many tables
Message
From
08/09/1998 15:20:49
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Grids with data from many tables
Miscellaneous
Thread ID:
00134192
Message ID:
00134192
Views:
59
I´m not totally sure about this, but it seems to work...

When you have a grid which needs data from many tables, using SET RELATION doesn´t work -- or at least I had problems with that.

A suggestion found here, in UT, is using form methods for accessing the needed data, and setting Column.ControlSource to ThisForm.MyMethod(). The methods are something like

SEEK some_key IN some_table
RETURN some_table.some_data

I have been trying skipping the form methods, and setting Column.ControlSource directly to a expression like

IIF(SEEK(some_key,some_table), some_table.some_data, "???")

and apparently it works fine, and is easier and faster than defining and calling methods.

I want to propose my "solution" (if it *is* a solution, and not a problem) to everybody... Any suggestions? Opinions? Bugs? Criticisms? Flames?
Next
Reply
Map
View

Click here to load this message in the networking platform