Note: I am fairly new to creating forms using InfoPath and I have zero experience writing code.
Here is what I want to do:
I am trying to create a form where our store managers can submit their location's payroll information each month. We already have a SharePoint list containing all current employees and the location that they work out of. I want the manager to be able to open the form, select the location they are submitting for from a drop-down list, and then have a repeating table automatically create one row for each employee in that location with the employee name already filled in, but the other columns left blank.
Is this possible? Is this possible with the standard features of InfoPath (i.e. without writing any code)?
Thank you in advance for your help!