Re: ERROR 1005: Can't create table (errno: 150)

[amol.viit]

mysql> CREATE TABLE Grants(grant_numb char(3) NOT NULL, source char(30), total_a
mt numeric(10,2), principle_researcher char(3),emp_numb char(3), PRIMARY KEY (gr
ant_numb), FOREIGN KEY grant2grantsource(source) REFERENCES Grant_source ON
UPDATE CASCADE ON DELETE RESTRICT, FOREIGN KEY grant2employee(emp_numb) REFERENC
ES Employee ON UPDATE CASCADE ON DELETE RESTRICT)engine=innodb;
ERROR 1005 (HY000): Can't create table '.\amolmore\grants.frm' (errno: 150)


this statement is not working man some one help me