Creating a Reference

You can create a reference that links a primary key, or alternate key, to a foreign key, or user-specified columns in both parent and child tables.

You can create a reference in any of the following ways:

Use the Reference tool in the Toolbox.
Select Model > References to access the List of References, and click the Add a Row tool.
Right-click the model (or a package) in the Browser, and select New > Reference.

Note: You can control whether the creation of a reference automatically creates a join between a primary key in the parent table to a foreign key in the parent table (default) or whether the join columns are left undefined with the Default link on creation model option (see Automatic Reuse and Migration of Columns).

For general information about creating objects, see Core Features Guide > Modeling with PowerDesigner > Objects.