Reject duplicate data input when data of two fields both found duplicate in another record

[shajibul]

I have an 'Employee' table, an 'Attendence_Type' table, and an 'Attendance' table. I input data in the 'Attendance' table through UX. There are 4 data fields, 'Attendance Date', 'ID', 'Name', and 'Attendance_Type' in the Attendance table. If any 'ID' and 'Attendance Date' are both found repetitive in any previous records, they will be treated as duplicate records. How do raise an error message for these and reject the input in the app?