Databases Reference
In-Depth Information
Intersection
An intersection table can be recognized by the fact that they also have—besides their
own ID—two IDs from the foreign keys. It's also possible that the intersection table
contains other foreign keys or columns.
Intersection table
We can implement an intersection table as a master detail page with an LOV, but
APEX also offers two alternatives to implement an intersection table—a shuttle
and a multiselect list. We can implement one of the driving tables as a base table and
use the other table as a lookup table. In the following screenshot we see an example
of a shuttle:
Shuttle
In the following screenshot, we can see the use of a multiselect list:
Multiselect list
