Primary and Foreign Key Options

Go to:

Application Explorer, Databases folder, Properties…

Use the Keys section to set the ‘Display Foreign Key As’ relationship.

Option	Description
Display foreign key as	If the database field contains a foreign key to another table, use the Display Foreign Key As option to specify which field in the foreign key table to display. <Display column value>. If this is selected, then the field value (foreign key value) is displayed rather than a selected field from the joined table. Note: Iron Speed Designer does not support setting Display Foreign Key As for composite foreign keys or composite virtual foreign keys. Only single, non-composite foreign keys may be used.
Virtual foreign keys	Specifies one-to-many relationships between related database tables and views that are not explicitly defined in the database. For additional information, see: Adding Virtual Foreign Key Relationships.
Virtual primary key	Specifies whether the field should be treated as if it were a primary key for the table or view. Zero or more fields may be selected which collectively comprise the primary key of the table (a composite key). For additional information, see: Adding Virtual Primary Key Relationships.