Cannot create foreign key on 2 VARCHAR(45) columns in MySQL Workbench 6.1
From the error message, what i can deduce is that a foreign key is trying to reference a table with a primary key of int, while it also has a primary key of int set on it's table, a bit confusing.

But try removing the primary  key on the referencing table like table two below, it should work fine.
so you could do something like


TABLE 1                   TABLE 2
Id(int)(pk)                   id(int)
name(varchar) ------ frontname(varchar)(fk)


or


TABLE 1                   TABLE 2
Id(int)(pk)                   id(int)(pk)
name(varchar)(pk2) ------ frontname(varchar)(pk2)(fk)


Not sure of the second one though