General information
Category:
Forms & Form designer
Title:
Grids with data from many tables
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only