Book a Demo

Author Topic: Foreign Keys...  (Read 3084 times)

betam4x

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Foreign Keys...
« on: November 10, 2011, 05:10:02 am »
My company is evaluating EA.  I currently have a database design i've mocked up for MySQL, but the foreign keys are somehow being corrupted.  

1)  I create the association.
2)  I right click on the association and hit foreign keys...
3)  I click a column from source and a column from target (note when i click the target column the source column is no longer highlighted, display glitch?)
4)  I choose 'No Action' for on update/delete.
5)  I click apply, both columns appear on bottom as expected.
6)  I close and reopen the foreign keys dialog, everything looks fine.
7)  I repeat for all tables.
8)  I go to generate DDL.  I click generate then view.  Only 2-3 foreign keys are listed.
9)  I go back to one of the missing foreign keys and the source column at the bottom is missing (but the target is still there).  I cannot click a source column.  I cannot edit the foreign key at all.
10)  Dropping it and recreating it still bugs out.
11) HELP!?

Using the latest version available as of today.
« Last Edit: November 10, 2011, 05:33:37 am by betam4x »