RE: (ROSE) Foreign Key Creation in Data Modeler

[Naiburg, Eric J.]

You must right click on a schema and select Data Modeler --> New --> Data Model Diagram.  If you create the relationships under that diagram and have primary keys in the parent table, the foreign key will be created.

 

Eric Naiburg
Rational Software Corp.
Mngr. Product Mngt.
e-Business Solutions
425-497-6124

-----Original Message-----
From: Enn Petersoo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 4:47 AM
To: [EMAIL PROTECTED]
Subject: (ROSE) Foreign Key Creation in Data Modeler

Hi,

 

I didn't find a way to create a Foreign Key in  the new model

in Data Modeler.

According to the Data Modeler help file

foreign keys are created automatically with the creation

of the relationship between a parent table (containing the Primary Key)

and a child table. And the primary key from the parent table migrates to

the child table.

 

But in my model creating relationship between tables doesn't

create a foreign key and the "migrated key"  tab of the relationship

specification is greyed (disabled).

 

Can somebody tell me what i am missing?

I couldn't find it in the help.

 

With regards,

 

            Enn Petersoo