Join (1:1) Relation with other Database Table |
  
|
Join (1:1) Relation with other Database Table |
|
It is possible to display data of a joined table (1:1) by using the Join element.
If you e.g. want to display attributes of a specific city which are not available in the Layer itself then it is possible to provide access to additional city specific attributes / fields by configuring a Join element.
For a Join it is necessary to specify a source table and a target table.
The source table is the table that contains the records which will get joined to records of the target table. The Join relation is defined by specifying a key field for each of the two tables used for linking the two tables (Key of source table, Key of target table).
In the sample below, the country name (CNTRY_NAME) fields of the two involved tables are used as key fields.
JOIN (1:1) configuration
Key of source table configuration
Key of target table configuration
Property |
Description |
Key of source table |
Key field of the source table to be used. Note: The Key field must be configured as ‘Result field’.  Result field of source table / Layer
|
Key of target table |
Key field of the target table to be used. Note: The Key field must be configured as ‘Result field’ in the Table configuration.  Result field of target table
|
Key of source table / Key of target table configuration
The joined fields simply get added to the Search result in the WebOffice 10 R3 client:
Joined fields in Search result of WebOffice 10 R3 client
See the subsequent chapter as well as chapters Database Connection and Tables for more details of Table and Database connection configuration.