quote:

---

You've probably got a record in table XXX with a value in the ATC_LVL_4_CD column that's not in the RDM_ATC_LVL_4_LKUP.ATC_LVL_4_CD column.

use...

This is the error i get when running the above

Number of referencing columns in foreign key differs from number of referenced columns, table 'dbo.RDM_ATC_DIM'.

Yes everything is consistent. The datatype, colwidth and colname. I tried dropping the same contraint thinking that it might be existing but it wasnt. any other thoughts