Trying out a foreign key. Have no examples to look at but this looks reasonable. Anyone know what the error refers to?
SQL query:
ALTER TABLE tblusers ADD FOREIGN KEY key1( emp_id ) REFERENCES tblcases(
emp_id
)
MySQL said: Documentation
#1005 - Can't create table '.\cvgsusers#sql-a8c_8a.frm' (errno: 150)
Nevermind, this worked:
ALTER TABLE tblcases ADD FOREIGN KEY key1( emp_id ) REFERENCES tblusers( emp_id )
