HI Folks

My component is structured in a lot of many to many relations.......

I think in JCook there are 2 main problems:

1. I am forced to use a surrogate primary key in a many to many relation table....

eg. (correct according to DBMS literature)

table: student_exams
Fields:
id_student
id_exam
other fields..........

same eg. (when I use JCook framework)

table: student_exams
Fields:
id
id_student
id_exam
other fields.........

2. In JCook, I'm unable to check duplicates in tables......this can cause Database inconsistency.....expecially in a many-to many-relation table.....

Proposed solution

Problem n.1 is marginal in JCook roadmap........

My idea is to use InnoDB Engine instead of MyISAM in order to impose referential constraints in tables.......could this work to prevent problem n. 2?

I think (but I prefer to be contradicted ) that cascade function to delete FK doesn't work properly or I don't understand how it works properly for my case study.....

Have a nice day