I'm using phpMyAdmin (PHP & MySQL) and I'm having a lot of trouble linking the tables using foreign keys.
I'm getting negative values for the field countyId (which is the foriegn key). However, it is linking to my other table and cascading fine.
When I go to add data there will be a drop selection for the CountyId and the values will look something like this:
" -1
1- "
Here is my alter statement:
ALTER TABLE Baronies
ADD FOREIGN KEY (CountyId)
REFERENCES Counties (CountyId)
ON DELETE CASCADE