Error When Creating Relationship In Data Model

[devnulled]

For some reason I can't seem to create a relationship between two tables even though I've successfully done it on many others in the same diagram.  I've only been using this product for a month or so, so maybe it's a user error

Here are the two tables I'm trying to create a relationship between, TransactionReports and DataEntity:



TransactionReports contains the PK of TransactionReportID, which should be the parent/constraint which I'm trying to map the TransactionReportID field in Data Entity to.  Here are the details for each of those fields in their respective tables:

TransactionReports



DataEntity



And here is the error when I try to create the relationship



Do you see anything that I'm doing wrong?  I've dropped both fields and recreated them several times, deleted all of the key/index/unique operations for both, and generally tried every combination I can think of and still can't get it to work.   Any help would be appreciated.  

Oh, I'm also using the latest build of v5.0 as well.  Thanks!

[Paolo F Cantoni]

Early testing on my part located a number of bugs in key management in pre 4.5 releases.  I'm not sure they got fixed.  When I found EA didn't yet handle DB Views - which I use extensively as part of my standard architecture, I've not got back to the DB side of things.

Most DB management and modelling programs (even specialist ones like Embarcadero ER studio) don't seem to understand that the target of a foreign key can be any candidate key in the parent.  This appears to be due to their marketing requirement to conform to the US Defence Department's IDEF1X modelling specification which also is fundamentally flawed in this area.  It took Embarcadero 4 years and 5 releases before they finally fixed my bug report.  The problem may be related to that.  Have you been able to make any alternate (a non-primary candidate unique) key the target of your foreign key?

HTH,
Paolo

[hd]

I'd suggest you submit a bug report directly to Sparx.