UltraLite Database User's Guide
  Utility Programs
    The UltraLite Schema Painter
      UltraLite Schema Painter dialogs

Create Foreign Key dialog

This dialog provides options for the creation of a foreign key.

The Create Foreign Key dialog has the following components:

• Foreign key name    Enter a name for the foreign key.

• Primary table    Select the primary table from the list of tables in your database.

• Eligible indexes    Select an index from the list of indexes in your primary table.

• Only check values on commit    Select this option to check values at commit, rather than upon insertion.

• Allow Null in the foreign key columns    Allows null values in the columns of your foreign key.

• Map    Click Map to map a column in your primary table, selected from the table above, to a column in your current table, selected in a subsequent dialog.