Hello
I am trying to create the form below. I am having trouble trying to figurre out how I could add the Abscent and Reason columns. The basic work flow is a date is selected from the calendar. A person selects a team which filters the spreadsheet below.
The spreadsheet pulls the FirstName, LastName, and Team from a table:
tblStaff
StaffID, First Name, Last Name, StaffCode, Team
The Abscent and reason column are generated and if they are filled in, the full entry is recorded in a table
tblAbscentIncidents
AbscentIncident, StaffID, AbscentDate, AbscentCode, AbscentReason
there is another table for the incident codes.
tblAbscentCodes
AbscentCode, AbscentName, AbscentDescription