I am working in a hospital management system and it has a requirement where a doctor can have only 7 appointments in a selected date. While creating an appointment the user has to select the patient and doctor and appointment date. There can be only 7 appointments on a particular day if it exceeds to more than 7 appointments then an error should be shown saying that appointments full for the selected day. How do i overcome this problem. TIA
