KeyTo Attribute Properties Tab

This tab allows you to define various aspects of about attributes that reference other views and is only available for attributes that are allowed to serve as foreign keys.

Option Description

KeyTo

The view that this attribute references. The value that appears in "<>" what Gatsby has derived as the default value based upon the relationship structure of your database. Specifying a KeyTo does not enforce the referential integrity at the database level. It only serves as guide for how your database is exposed through the Gatsby interface.

Only views that have a primary key that is compatible with this attribute are available in the list.

Lookup

This view from Gatsby derives the drop-down list values. If a lookup is not specified, the drop-down list will be populated from the view specified in KeyTo.

Show

If checked, items from this view will be available from on the related row's form.

Caption

The label used to identify items from this view on the related row's form.

Dependent

If checked, items from this view will appear as a sub-form on the related row's form.