Mapping ADC database relationships to Vocabulary Associations
Automatic mapping of associations works substantially the same as entities. However, rather than entry text boxes and pulldowns for mappings, a more visual approach is provided. If an automatic match is made by the system, it is displayed in grey as shown:
If you want to revise the join expression, click on the Join Expression Property Name, as shown:
The Join Expression dialog box opens with a deconstruction of the join expression, as shown:
Use the pulldown lists in each column to refine the join expression. You can add lines to define complex join expressions where appropriate. As all revised join expressions are not validated, they are always displayed in black.
Note: The join expression is used by ADC to form associations in memory. The join expression is parsed by ADC -- it is not sent to the database server as part of a query.
