I have a database which two of the fields are size and size_qty.
What I need is:
when one of my staff is placing a order and they come to the size field the will pick the size from the size table drop-down. Like XL and then in the size_qty the amount of that size.
Sometimes there are many sizes for the order. How would I handle adding more sizes and qty when I don't how many sizes they will be. I don't want to have multiple size field's in the table. Unless I have to.
If I have to have many size and size_qty fields in the table how would I not show all the fields at once, but show them as needed?
I guess what I need is a dynamic size and size_qty fields in a table.