@RCarignan - as I am not familiar with your work process, forgive the clarifying questions.
You say you want to:
to scan items and track human tissue:. Data includes: product code, serial number, purchase order, receive date and implant date.
What i am not clear on is, when you “scan items”, is this one product code per row? Or is this really multiple product codes per purchase order (where the multiple PO line items have unique serial numbers)?
When you asked about multiple serial numbers, did you really mean you have multiple unique rows per PO?
Just trying to get clear what your data structure is. And again, I suspect you just need to set up your data as parent-child tables so you can have many serial numbers per PO.
I may have your use case wrong, so please help us help you by describing the data structure. Also, reading the References info link above may help you better understand how to approach this.