Key is not primary
Posted: Sun 22 Nov 2015 21:56
Hi,
I am working with a legacy database. It has some design mistakes. One of them being that there is a foreign key on a table that points to another field on another table which is not the primary key (but is unique).
EG :
USERS
----------
ID (PK)
User (Unique)
MANDATES
----------------
ID (PK)
User (FK on USERS.USER)
If I use EntityDAC to set MANDATE.USER = USER1, I get an error
"Key is not primary".
Any way I can get this to work?
I am working with a legacy database. It has some design mistakes. One of them being that there is a foreign key on a table that points to another field on another table which is not the primary key (but is unique).
EG :
USERS
----------
ID (PK)
User (Unique)
MANDATES
----------------
ID (PK)
User (FK on USERS.USER)
If I use EntityDAC to set MANDATE.USER = USER1, I get an error
"Key is not primary".
Any way I can get this to work?