I'm trying to create a work order database to organize my clients and their orders. I am a t shirt printer and so when I input data I want to be able to select what product they want and how many of each size in that product.
Example: Client 1 wants T shirt A: 6 smalls, 10, mediums, 5 Larges. Client 2 wants T shirt B: 4 smalls, 5 mediums, 10 larges, 4 extra larges.
I think yes. Create a records / table that looks like this. You don't really need one, but the order number can be an auto increment number field which can be used to sequence orders based on when they come in.