Hello everyone,
I'm new with InfoPath and working on creating a form to assist employees in a shift selection process.
The form I created has one drop down with a data connection to a SharePoint page with an employee names.
And I have two repeating tables one that extracts employee information like rank etc... The second repeating table has a different data connection which will extract shifts based on data in a text box and using a button. I want the second repeating table to extract shifts based on employee information from the first repeating table from one specific cell as a criteria, but I've hit a wall and haven't been able to pull it off.
Ideally the form should function with an employee selecting their name and the second repeating table will show a list of shifts they can select then submit to be published on SharePoint. Any help is greatly appreciated.
Thanks for your help.