Versions Compared

Old Version 1

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version 2

changes.mady.by.user Alejandra Rivera

Saved on

Key

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

&<img src="../resources/images/opentocr.png" title="Open Contents list" border="0"&>
You are here:

...

Example 1
Retrieve a customer description to be displayed when processing an order:

...

Based on the access routes between the Section table and the Department table, a PJC is added to the Section table so that the Description of Department column is a table lookup to the Department Description in the Department table. Description of Department is a virtual column. When it is used by a function, the Repository will actually access the Department table to get the required data since it does not really exist in the Section table. The access route is used to determine how to access the data.
Based on the access routes between the Department table and the Section table, a PJC is added to the Department table so that the Section Count column is calculated by counting the appropriate sections in the Section table. Section Count is a virtual column. When it is used by a function, the Repository will actually access the Section table to get and total the data.
Also See
Predetermined Join Column Concepts
&<img src="../resources/images/opentoc-dark.png" title="Open Contents List" border="0"&>