Hi!
I want to make a PHP report using standard tables "emp" & "dept" using the parameter input of the type of deptno & get the filterd records based on the fields( Empid, sal, deptname).Though I have put a foreign key constraint in the emp table on the field deptno(using Mysql),on entering the record in emp table - it takes the invalid values also.ie. those not existing in dept table.
The ref. manual of Mysql states that the F.K constraint dosen't check the referencing table.
How do I get around this problem ?
I want to make a PHP report using standard tables "emp" & "dept" using the parameter input of the type of deptno & get the filterd records based on the fields( Empid, sal, deptname).Though I have put a foreign key constraint in the emp table on the field deptno(using Mysql),on entering the record in emp table - it takes the invalid values also.ie. those not existing in dept table.
The ref. manual of Mysql states that the F.K constraint dosen't check the referencing table.
How do I get around this problem ?