I’m writing to seek assistance with a project in MS Access 2013. I have a sample database that records imaging equipment that is shipped to different study sites, but managed under one study. One study can have several different study locations. So, my database is a log for each system shipped to each study site. Each site would receive the same hardware configuration. I need a solution to automate this in VBA Code. I've tried an update query, but that will not work in this situation. I need to tell the code how many copies of a system a study requires.
The work-flow currently allows the project manager to create the "study" for a given sponsor. He/She will then create the "system" that will be used for that study. He/She will select hardware items from a drop down list and will create the "system". We want to then copy this initial entry however many times is required by study. I am looking to accomplish this task by have a button either at the system level or study lever that will execute this task.
To assist, I have attached a sample of the database in question. Once opened, you will arrive at the Study Page. Here you can see the systems created per study.
Many thanks in advance to anyone who can help.