I am creating a Timesheet system within SharePoint and currently have two lists: Active Employees and Timesheet. Active employees has the following single-text fields: Employee Name, Employee ID, and Department. I set up a data connection so that the Department field in Timesheet pulls departments from Active Employees.
I want to fill out the ...