I am a nooby so some guidance would help. I am going through Larry's book on Chapter 6 where this subject of FOREIGN KEYS starts. I am trying the create the transactions table but get the error
#1215 - Cannot add foreign key constraint
This error came up using PHPMyAdmin, I tried using the command prompt which also failed, but the error message there was too vague, I rechecked and retyped the code several times with the same result. Is there possibly a typo in the book, what else could be wrong?
I have been stuck here for a few days I need to move to the end of the chapter and more.
Ian