My company is trying to use Infopath to collect a simple set of data through an Infopath form that submits into an Access Database.
The information being collected is as follows: Employee ID, Date, Hours, Activity, # of Activity Performed in Hours Entered
It is possible that the Employee have multiple activities for the same day and we'd like for the employee to only have to enter their Employee ID and Date once and then add as many rows as needed for their individiual activities. Upon submission we want the rows going into MS Access db to have all fields. Not sure how to do this, but am guessing it isn't that difficult.
Thank you!