Solve some code errors

This is a cakePHP project involving a database to store data of documents. You can check the project here: [login to view URL] Using Firefox. These errors must be solved when using document/[login to view URL]: - If you add a document: - you can't add a new publication place if it doesn't exist in publication_places table. A new plublication_place -> country association can't be made if you add a new publication place that doesn't exist in publication_places table. - If you edit a document: - you can't delete an authority. - you can't add a new authority. - a collection can't be deleted, and it is not formatted as the other fields. - you can't add a more than one publisher. - you can't add a new publication place if it doesn't exist in publication_places table. A new plublication_place -> country association can't be made if you add a new publication place that doesn't exist in publication_places table. There should be added as well: - After saving a document (after add or after edit), open new window linking to languages/edit/(id of the language that has been inserted using the documents/[login to view URL] and documents/[login to view URL]) To understand how authorities work: Imagine these Tables ================= Authors id name 1 Smith, John 2 Parker, Sarah 3 Ward, Jason Author_types id name 1 null 2 [illustrator] 3 [translator] Authorities id author_id author_type_id 1 1 1 2 1 2 3 2 1 4 3 1 5 3 3 Case 1: - You type "Crosby, Bill" and input finds nothing, then: - question message: "Crosby, Bill is not in the list of authors, do you want to add it?" - table authors ADD name "Crosby, Bill" (new id will be: 4) - table authorities ADD author_id = 4, author_type_id = 1 (1 is the default value when nothing is inside []) Case 2: - You write "Smith, John [translator]" and input finds nothing. - question message: "Smith, John" is not in the list as [translator], do you want to add it?] - table authorities ADD author_id = 1, author_type_id = 3 Case 3: - You wrtie "Smith, John [prologue]" and input finds nothing. - quesiton message: "[prologue]" is not on the list of author types, do you want to add it? - table author_types ADD name [prologue] (new id will be: 4) - question message: "Smith, John" is not on the list as [prologue], do you want to add it? - table authorities ADD author_id = 1, author_type_id = 4 Case 4: - You write "Crosby, Bill [prologue]" and input finds nothing. - question message: "Crosby, Bill is not in the list of authors, do you want to add it?" - table authors ADD name "Crosby, Bill" (new id will be: 4) - quesiton message: "[prologue]" is not on the list of author types, do you want to add it? - table author_types ADD name [prologue] (new id will be: 4) - question message: "Crosby, Bill" is not on the list as [prologue], do you want to add it? - table authorities ADD author_id = 4, author_type_id = 4 Both in documents/[login to view URL] and documents/[login to view URL]