Re: Simple entity relationship and foreign key question

[David McMurray]

What an idiot I am! The "games.map_id" column was defined as INT(10) and the "maps.map_id" column was just defined as INT!

I've changed the latter to INT(10) and I can now tick the right column and placing the mouse over the relationship now highlights the map_id columns in both tables as I would expect it to.

Although I did get an error when unticking the auto-created foreign key column which said "Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. External component has thrown an exception." This also then occurs when ticking the column I do want to use as the foreign key.