Originally Posted by
Ant_Snell
Thanks Davegri,
How can I check if the constraint does forbid duplicate keys? I saw the reference to duplicates in the error massage but don’t understand what it is telling me. The child table only contains one foreign key (Emp_ID) related to Emp_ID in the parent table. The data will only contain one value of a type e.g. if the employee has an Alert (Allergy, Phobia etc.) they may have one of each but never the same one twice. Emp_ID is used as a foreign key in other tables e.g. addresses, contact numbers, etc. but surly I don’t need to give it a different name in each table? The one to many relationship works fine in Access but MySQL will not allow me to create it in the workbench.