|Relational Database Definitions|
The following terms deal specifically with Subforms, Posts and Abacii containing Lookup or Sub tiles and refers to how data from two different Relations are linked
Primary and Foreign Keys
Source and Target
The first hole contains the Target Field or Abacus you are looking up. The fourth hole is the Target Relation that you will be looking in. The Links or Keys are in the second and third holes. The second hole of a Lookup tile contains the Target Link. The third hole contains the Source link. The Source Link will trigger the Lookup into action. When the Source Link is defined 9for example, data is entered in the Source Link Field on a View), the Lookup will search the Target Relation for a record where the Source Link field equals the Target Link Field. When it finds the record, data from the Target Field in the first hole becomes the result of the Abacus.