1:1 Relation With Key Field Definition

In case of multiple 1:1 connections, it might be important for the user to see which of the key fields are linking the tables together. In this case you can declare the fields as follows:

<parent table>.<key field parent table>@<linked table>.<key field linked table>:<field name>, e.g.

OrderDetails.OrderID@Orders.OrderID:OrderDate

(SQL equivalent: "SELECT OrderDate FROM Orders WHERE OrderDetails.OrderID= Orders.OrderID")

Now the key field declaration is displayed in the tool window list of variables next to the table name:

Again, remember to update the field contents when the parent table is printed!