Just a guy who wants to learn...
My goal is to update Attendace table easier by having a form where i could choose a team from a combobox and based on that value in a subform to have all the employees names associated with that team displayed one under another with DateAttendance, Hours, Minutes fields blank (from Attendance table) so i can input relevant data daily for all in the same time by pressing a Save button in that subform.
The association between employees names and teams is done in the query called ActiveEmployees that takes its data from Employee table where i removed the ones who have an end date associated to their names, which means that they no longer work with us.
Any help will be appreciated!!!
I attached the draft! Thank you!