Modifying Device Designs › Editing Report Designs › Example 1: Simple Report Design › Relations

Relations

Consider the following relations to model customer information by geographical region:

FIL   Country   REF   Known by   FLD   Country code     CDE
FIL   Country   REF   Has        FLD   Country name     TXT

FIL   Area      REF   Owned by   FIL   Country          REF
                                 VRT   Country name     TXT
FIL   Area      REF   Known by   FLD   Area code        CDE
FIL   Area      REF   Has        FLD   Area name        TXT

FIL   Customer  REF   Owned by   FIL   Area             REF
                                 VRT   Country name     TXT
                                 VRT   Area name        TXT
FIL   Customer  REF   Known by   FLD   Customer code    CDE
FIL   Customer  REF   Has        FLD   Customer name    TXT
FIL   Customer  REF   Has        FLD   No of machines   NBR

If you wanted to produce a report of customers by geographical region, you would need the following information: