I'm trying to create a foreign key. The columns in both tables are VARCHAR(45) and neither is a PK, however I keep getting this error message:
It is saying the PK of reference table is INT, which is true, but I am not referencing this column, I am referencing another column in this table that is VARCHAR(45).
I have already made to FK in this same table where both columns are VARCHAR(45), which is why I am wondering what I am doing wrong this time.
Just figured it out.
The reference table column needed to be a Unique Index, then the foreign key worked.
Not a DB guy, but that sounds like a rookie mistake on my part.