Share via

Lookup Table Properties

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

When you select a lookup table in the Solution Explorer, the following properties appear in the Properties window.

  • CurrentTableColumn
    The name of the column in the lookup table that is being used as a foreign key in the main table.
  • ParentTable
    The name of the main table or detail table above the lookup table in the hierarchy.
  • ParentTableColumn
    The name of the column in the main table or detail table that points to the lookup table.
  • Relationship
    Displays the Primary Key/Foreign Key relationship between the lookup table and the main table or detail table.

See Also

SQL Server Workflow Properties Pages | Defining Hierarchy Schema