I have made some tables and created relationship from phpmyadmin.
Relationship is as below
[IMG]http://img295.imageshack.us/img295/2411/relationship.jpg[/IMG]
Problem is that requisition table allow material id which is not in material table. what is the problem. How can I solve this.
Simply Foreign key can not be such value which is not in primary key. How can I do that