Set your relation to patientno from appointment table to patients table in the DataEnvironment. Check also your form's textbox for patient's name that your control source is set to patient.patient_name (whatever field you use in the patient table).

Hope this help