At 02:15 PM 1/26/2010, Steve Vellella wrote:
If you have common columns between the "header" and the "row" table
you have to make sure the data matches or the detail info won't show.
And, if you don't know the exact columns and the relationship between
all tables involved in a form, you may use RColumnAnalyzer.RBL Plugin
to visually display the relationship when used as "One-To-Many" or
"Many-To-Many".
Example:
IF (CVAL('DATABASE')) <> 'dbname' OR (CVAL('DATABASE')) IS NULL THEN
CONNECT dbname IDENTIFIED BY owner password
ENDIF
PLUGIN RColumnAnalyzer76.RBL vResult -- 7.6 for Windows
PLUGIN RColumnAnalyzer80.RBL vResult -- Turbo V-8 for Windows
PLUGIN RColumnAnalyzer vResult -- R:BASE eXtreme 9.0
PLUGIN RColumnAnalyzer90 vResult -- R:BASE eXtreme 9.0
PLUGIN RColumnAnalyzer90.RBM vResult -- R:BASE eXtreme 9.0
Select all associated tables in a form and click on desired Table
Relation to see a list of common columns.
That should provide you with some blue's clues!
Very Best R:egards,
Razzak.
