relating tasks to surveysFurnitures generates this error
Quote:A Database Error Occurred
Error Number: 1054
Unknown column 'surveysfurniture_surveysFurnitures_tasks._id' in 'on clause'
SELECT `tasks`.*, `surveysfurniture_surveysFurnitures`.`id` AS surveysFurniture_id, `surveysfurniture_surveysFurnitures`.`pointNumber` AS surveysFurniture_pointNumber, `surveysfurniture_surveysFurnitures`.`easting` AS surveysFurniture_easting, `surveysfurniture_surveysFurnitures`.`northing` AS surveysFurniture_northing, `surveysfurniture_surveysFurnitures`.`section` AS surveysFurniture_section, `surveysfurniture_surveysFurnitures`.`location` AS surveysFurniture_location, `surveysfurniture_surveysFurnitures`.`defectTo` AS surveysFurniture_defectTo, `surveysfurniture_surveysFurnitures`.`damage` AS surveysFurniture_damage, `surveysfurniture_surveysFurnitures`.`priorityID` AS surveysFurniture_priorityID FROM (`tasks`) LEFT OUTER JOIN `surveysFurnitures_tasks` surveysfurniture_surveysFurnitures_tasks ON `tasks`.`id` = `surveysfurniture_surveysFurnitures_tasks`.`_id` LEFT OUTER JOIN `surveysFurnitures` surveysfurniture_surveysFurnitures ON `surveysfurniture_surveysFurnitures`.`id` = `surveysfurniture_surveysFurnitures_tasks`.`_id` WHERE `tasks`.`id` = '1'