I want to join Employee and Employee-Attendance tables having following columns:
Employee: id, badge_number
Employee-Attendance: badge-number, check_in_out_time
The join should be on the basis of badge-number (unique for each employee) instead of id column.
How can I declare the models and then view all Attendance records for an employee from ‘Relate’ button.