SELECT evaluations.*, evaluationhdr.EvaluationName FROM evaluations, evaluationhdr WHERE evaluationhdr.EvaluationCode = evaluations.EvaluationCode AND evaluations.EvaluationCode = "#Form.EvaluationCode#" AND evaluations.FirstName = "#Form.FirstName#" AND evaluations.LastName = "#Form.LastName#" UPDATE evaluations SET DateStarted = #CreateODBCDate(Now())# WHERE ID = '#Client.EvaluationID#' ICS-CONNECT Team Evaluation