mysql error 1215
I'm guessing that Clients.Case_Number and/or Staff.Emp_ID are not exactly the same data type as Clients_has_Staff.Clients_Case_Number and Clients_has_Staff.Staff_Emp_ID.
Perhaps the columns in the parent tables are INT UNSIGNED?
They need to be exactly the same data type in both tables.