creating foreign keys in a single recursive table

[dougwscott]

How is the above done within EA's class modeler for tables (class with stereotype "table")?  The classic example: an Employee table with a PK of EmplNum and a column called ManagerEmplNum that contains the EmplNum value of the manager of the Employee. I have tried EA's "foreign key assignment" approach via the association, but without success.    

[KP]

I just tried it and it works for me. Here's what I did: Create a table, set its database, add two attributes of the same type, make one the primary key, add a reflexive association to the table, open the foreign keys dialog for the association, select the foreign key field at the source end and primary key field at the target end.

If you did all that without results, maybe send an e-mail to our support team telling them step-by-step exactly what you are doing and they should be able to spot the missing step.