Primary and Foreign Key Options

Use the Keys section to globally set field properties, including foreign key relationships and to define new foreign key relationships.

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 the database table joined by this field. The list contains the names of all the primary keys in all other tables within the same database in the form <TABLE>.<FIELD>. Composite foreign keys display multiple fields (rows) with foreign key references back to the corresponding key fields in the primary table. For additional information, see: Adding Virtual Foreign Key Relationships.
Virtual primary key	Specifies whether the field is a primary key for the table. 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.