Microsoft KB Archive/930579

= You receive an &quot;Error L3022&quot; message when you validate a database schema in Visio for Enterprise Architects =

Article ID: 930579

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Visio for Enterprise Architects 2002

-



SYMPTOMS
Consider the following scenario:
 * When you define a relationship in a Microsoft Office Visio database model, you select the same column from a table as the primary key column and the same column as the foreign key column.
 * You extract the database schema from the database by using reverse engineering.
 * You validate the database schema in Microsoft Visio for Enterprise Architects.

In this scenario, you receive the following error message in the output pane:

Error L3022: Self-referencing foreign key column ' ' cannot exist as both a parent and a child in the same relationship.



CAUSE
This problem is caused by limitations in the database modeling solution in Visio. Visio supports self-referencing relationships between two different columns in the same table. However, Visio does not support a relationship that has the same column for parent and child.



WORKAROUND
To work around this problem, create a valid self-referencing relationship between two distinct columns in the table.



STATUS
This behavior is by design.

Keywords: kbexpertisebeginner kberrmsg kbtshoot kbprb KB930579

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.