Document toolboxDocument toolbox

Bridge node

To provide insights into data, you can break a many-to-many relationship into two one-to-many relationships by using a third table, called a bridge table or bridge node. Each record in a join table includes a match field that contains the value of the primary keys of the two tables it joins. (In the join table, these match fields are foreign keys.) These foreign key fields are populated with data as records in the join table are created from either table it joins.

Specify the bridge node using the Node Type field in the Properties pane.

Copyright Kyvos, Inc. All rights reserved.