Using Your Model › Edit Database Relations Panel

Edit Database Relations Panel

The Edit Database Relations panel is the center of CA 2E.This panel enables the designer to enter relation statements that define a model. Each statement uses file and field names that assert a declaration about your model or application; for example, Order Known by Order Code.

EDIT DATABASE RELATIONS            SYMDL                                       
=>                            Rel Lvl:                                         
 ? Typ Object                 Relation     Seq Typ Referenced object           
    FIL Order                 Known by      10 FLD Order code                  
    FIL Order                 Has           20 FLD Order date                  
    FIL Order                 Has           30 FLD Order status                
    FIL Order                 Refers to     40 FIL Customer                    
    FIL Order                 Refers to     50 FIL Employee                    
    FIL Order                 Refers to     60 FIL Product                     
    FIL Order Detail          Owned by      10 FIL Order                       
    FIL Order Detail          Known by      20 FLD Order line number           
    FIL Order Detail          Has           30 FLD Order quantity              
    FIL Order Detail          Has           40 FLD Line total                  
    FIL Order Detail          Refers to     50 FIL Product                     
                                                                               
                                                                               
                                                                        More...
Z(n)=Details   F=Functions   E(n)=Entries   S(n)=Select   F23=More options     
F3=Exit   F5=Reload   F6=Hide/Show   F7=Fields   F9=Add/Change   F24=More keys 

The Edit Database Relations panel has a number of edit and navigation aids that expedite model design and maintenance.