Post reply

The Alter table statement confilcted with the Foreign Key Conctraint

  • January 18, 2018 at 4:17 am

    #325495

    Hi,

    i am creating RI in ms SQL Server BE (Access is FE).
    Problem is that i have Table Slownik with field Slownik_Id varchar(50). 
    I want to create relationship with table tbl_Korekty.[Slownik_ID_FK] an error. 

    How can i fix the issue? What is the cause?

    Please help,
    this is urgent,
    Jacek 

  • January 18, 2018 at 4:39 am

    #1976295

    Jacek

    I think the problem is that you have one or more values of Slownik_ID_FK in Korekty that don't correspond to a value of Slownik_ID in Slownik.  You'll need to clean the data before you can create the foreign key constraint.

    John

  • January 18, 2018 at 4:55 am

    #1976297

    John!

    Thank you very much!
     You have right ! I cleaned data (deleted in tbl_Korekty) and now it is working!

    BesT,
    Wishes

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply