Inventory Troubles

I am in the process of building an app to track inventory. The biggest problem that I face is that some items are tracked by serial number, while others are tracked by quantity. I want to be able to use my Purchase Order table to input the quantity purchased, then create that many new records in my inventory table (where I can input the serial numbers if need be) when I click a checkbox. Alternatively, I wouldn't mind inputting the serial numbers in the PO, but quantities could range from 1-200, and creating 200 separate "serial number" fields (and then automations after) seems like a lot of extra work that can probably be avoided.

------------------------------
Katlyn Allen
------------------------------