filling a repeating table based on selection
Posted on 2008-10-10
We are creating an infopath form for adding a new user to our network. We are a financial institution, so we have many applications that we need to add access for. We would like to create a form in which one secion is the employee information (i.e. Name, Location, Position) and a repeating table below that is the applications needed for the Position (field). When i select a position I would like the repeating table to fill in a row for each application needed so that each officer could check off that particular application when complete. Is there a way to do this?
I have an access database created with all the necessary data (for both queries as well as submission). Ideally the employee table would populate with the top portion of the table, and the Application table would populate with a record number (for indexing purposes) as well as a completion status. Any help is greatly appreciated.