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 Timesheet for multiple employees at once. If I select one department (for example, Call Center), I want it to automatically pull all the employees listed under that department. If I have two Call Center employees, I want the Timesheet to automatically create two repeating items, pulling their names and ID's. Is this possible? And if so, how can I go about setting this up?