I have an idea, I'll post back to let you know how it's working. When the serial numbers are first entered, they should be separated by a comma. There will be a formula field for each possible serial number (there shouldn't be more than 12 at most) which pulls a specific serial number using the
"part" function. Those field will be used as lookup fields on a child table, where I will use the "copy this field" function for every field, twelve times, and label and arrange them on the form so that they correspond to a specific serial number.
