Data Modelling Issue

[rhoff999]

I cannot seem to be able to create multiple Foreign Keys to the same table.

Lets say I have two tables, tblChild (PK ChildID) and tblParent (PK ParentID) and I want to have two columns defined in tblChild:
NiceParentID
MeanParentID

I cannot in the Table Designer create two FK associations.  This forces me to keep these Foreign Key definitions outside of the model, which will become a maintenance nightmare.  I also do not want to normailze tblChild to remove the dual uses of a column in a single table.  Any help would be appreciated.

[Bruno.Cossi]

Hi,

what exactly is the problem? I just tried drawing two associations between the two tables, and everything seemed to be ok.

Bruno

I cannot seem to be able to create multiple Foreign Keys to the same table.

Lets say I have two tables, tblChild (PK ChildID) and tblParent (PK ParentID) and I want to have two columns defined in tblChild:
NiceParentID
MeanParentID

I cannot in the Table Designer create two FK associations.  This forces me to keep these Foreign Key definitions outside of the model, which will become a maintenance nightmare.  I also do not want to normailze tblChild to remove the dual uses of a column in a single table.  Any help would be appreciated.