Linking tables

[Thomas Mercer-Hursh]

I have just downloaded 11, having not done any meaningful modeling in EA for quite some time.  I am building a data model and have two tables defined, one of which contains a column which is the primary key of the other.  I can't remember or find how I show this.  I can get an association between them easily enough, but there is no indication of the columns which participate in this association.

[skiwi]

Yes, I thought that you would specify from the Association properties, e.g. Source and Target roles, but it never worked well for me.
Or perhaps under the entity properties, e.g. Related Links.

In fact you ...

Right mouse click on the association connector and choose Foreign Keys (EAUI)

Make sure the database is defined for each table, and tables have the appropriate columns.

[Thomas Mercer-Hursh]

Wonderful, thanks!

[Thomas Mercer-Hursh]

Which I create one of these foreign key relationships, I get 6 labels - 2 for cardinality, one for FK_Table1_Table2, one for PK_Table2, one for column = column that makes the join, and FK associated with that.  While clear, this makes for very busy diagrams, especially as the FK_Table1_Table2 labels can be quite long in my case.    Is there any way to control what shows up in a systematic way without hand deleting and/or editing each instance?  Really, the cardinality and the column = column labels say it all.

[skiwi]

I wish

Label visibility
Default Visibility for Data Modeling Association
v9Beta 3 - property to hide labels on diagram
Set label visibility for all connectors
Editing properties
set the label visibility for all connectors in a diagram
8.0 diagram enhancements
Setting label visibility.
Show join condition for foreign key (hide PK, FK)

As you can see this is a popular request dating back to at least V8.
All I can suggest is that you put in a feature request (and tell us when you have done so)

Ability to change Sparx direction
Achieving enhancements

[Thomas Mercer-Hursh]

I see ... oh well.