I have an Excel workbook with two sheets. The first sheet contains a list of applications per user. The second sheet contains machine details. I need to create an access form showing the data from both sheets. The issue I have is that users can have multiple applications and/or machines.
The screenshot below is what i have got so far, but I need all the applications on one record/form per user/machine.
The blank fields in the table require filling in. So in theory it's like a questionnaire
I have attached a sample workbook.
Or if this is not possible perhaps it can be done via a report