Foreign Key Implementation Error Because of DataType Mismatch

Certified Senior Developer

Hi All, I am getting a datatype mismatch erro when I am connecting and creating a fk from a pk from another table.
Each and every confirguation is same for both the columns except the following:

  • PK column is default none with auto increment
  • FK column is default null 

Can you please guide me on what mismatch I am missing as this is a usual case and easily implementable.

  Discussion posts and replies are publicly visible

Parents Reply Children