Kbase P33678: How to create a Relationship between tables CHAR RESULTS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/27/2008 |
|
Status: Unverified
GOAL:
How to create a Relationship between tables CHAR RESULTS
GOAL:
Relationship between tables is not recognised in RESULTS
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
1.) Start results:
results dbname
2.) A. Administration -> R. Relations Between Files
<select> table1
<select> table2
[1]of dbname.table2 [F1]
[F4]
"Select an option or press [F4] to exit and save changes."
-> [F4] -> are you sure? "YES"
3.) R. Reports -> D. Define -> table1
-> Select Related File:
table2 (dbname)
# now it's just a matter of selecting the fields needed for the report.
# once the fields for the report have been selected, the "info" will confirm:
"File #1: dbname.table1
File #2: fi.table2
Relation: OF dbname.table1
.... etc
In addtion the dbname.qc tail will show:
message= "Loading list of relations"
join1= "dbname.table1" "dbname.table2" "OF fi.table1"