I know next to nothing about Access, so please forgive me.
I work in a research lab in which people from other departments can submit samples for testing. Many times, there are multiple samples of the same material requiring the same testing simultaneously- may differ by size or process, but...