Table parent-child

[kgish]

I have a table with the following fields:

ID - (PK) not null
ParentID - (FK)
Description -  not null

How can I use an association to represent a link between the ID and ParentID fields within the same table?

[Bruno.Cossi]

Hi,

simply create the table and columns, mane sure you mark "ID" as a primary key. Then create an association from the table to itself, go to the association's properties and in the source role tab specify ParentID as the role, in the target role tab select your primary key (not the column, the primary key itself) as the role.

Hope this helps!
Bruno

I have a table with the following fields:

ID - (PK) not null
ParentID - (FK)
Description -  not null

How can I use an association to represent a link between the ID and ParentID fields within the same table?

[kgish]

Hey, that works like a piece of cake, thanks. It never struck me that I could drag the association from and to the same table.

[Bruno.Cossi]

No problem :-) A good way of figuring these things out is to create the table in the database and reverse-engineering it into EA.

Bruno