created new validation for most recent visit not being in future
fixed many issues related to updated and deleting records