In library management system,
i have stud_reg table of registration, which i give primary key of stud_id field, if student registered than the primary key is start, and i have another tables like book_issue and stud_tab. In book_issue table has fields of stud_id which i give foreign key and store records of book issue transactions. In stud_tab has field of stud_id which i give foreign key ; store all information like, stud_id, book_id,book_name, issue_date, return_date and if late deliver than fine field in it. now, e.g. student want software engineering book and click on issue button than records will inserted but, there is error: foreign key constraint that u don't add or update any records from child to parent. this ok, but, what can i do for issue that book to particular student? there is any way to issue and insert records. thanks for reply..............