Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

[ Image Removed |../../index.htm#lansa/ugub_30048.htm]
You are here:

...

This window is displayed when:

  • The relationship is 1 to 1
  • Reviewing Predetermined Join Fields
  • Changing Predetermined Join Fields
  • Creating Predetermined Join Fields
  • Deleting Predetermined Join Fields

...


 
 DC@P200904         Select Fields from Source File                     
                                                                       
 Access Route: XXXXXXXXXX   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  (XXXX )
 Source File:  XXXXXXXXXX   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX         
                                                                       
 Select   Source field to define Predetermined Join Fields             
                     ..........................................        
  Sel   Field       D:        Nominate Join Fields            :en Dec  
   _    XXXXXXXXXX  X:                                        :99  9   
   _    XXXXXXXXXX  X:    Look Up...  XXXXXXXXXX              :99  9   
   _    XXXXXXXXXX  X:    Keep Last.  999                     :99  9   
   X    XXXXXXXXXX  X:                                        :99  9   
                     :                                        :        
                     :                                        :        
                     :                                        :        
                     :   Fnn=Help  Fnn=Exit  Fnn=Cancel       :        
                     :    Fnn=Messages  Fnn=Change            :        
                     ..........................................        
                                                                       
 Fnn=Help  Fnn=Exit  Fnn=Cancel  Fnn=Messages                          
                                                                       
 

 |
This window is displayed when:

  • The relationship is 1 to many
  • Reviewing Predetermined Join Fields
  • Changing Predetermined Join Fields
  • Creating Predetermined Join Fields
  • Deleting Predetermined Join Fields

...


 
 DC@P200905         Select Fields from Source File                     
                                                                       
 Access Route: XXXXXXXXXX   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX  (XXXX )
 Source File:  XXXXXXXXXX   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX         
                                                                       
 Select   Source field to define Predetermined Join Fields             
                     ..........................................        
  Sel   Field       D:        Nominate Join Fields            :en Dec  
   _    XXXXXXXXXX  X:                                        :99  9   
   _    XXXXXXXXXX  X:    Total.....  XXXXXXXXXX              :99  9   
   _    XXXXXXXXXX  X:    Maximum...  XXXXXXXXXX              :99  9   
   X    XXXXXXXXXX  X:    Minimum...  XXXXXXXXXX              :99  9   
                     :    Average...  XXXXXXXXXX              :        
                     :    Count.....  XXXXXXXXXX              :        
                     :                                        :        
                     :   Fnn=Help  Fnn=Exit  Fnn=Cancel       :        
                     :    Fnn=Messages  Fnn=Change            :        
                     ..........................................        
                                                                       
 Fnn=Help  Fnn=Exit  Fnn=Cancel  Fnn=Messages                          
                                                                       
 

 |
Working from Nominate Join Fields window you can:

...

If a partial name or '?' is entered a single field selection screen is displayed. The selection list will be built from the fields in the LANSA data dictionary. Refer to 3.10.1 Select Fields When Working from File Definition Menu for more details.
[ Image Removed |../../index.htm#lansa/ugub_30048.htm]