Key is not primary

[ludydoo]

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?

[AlexP]

Hello,

Please send the project and model, on which the error occurs to support*devart*com.