I'm doing an inventory system project, and I've already done the part where product balances can be checked out or checked in.
However, I'm trying to record the transactions now and I'm abit stumped because 1 transaction may 1 or more product and value.
For example, withdrawal Transaction A:
1. Pots - 10, 5
2. Pans - 4
3. Plates - 20
As the number of items in the transaction can vary from 1-50, the only way I thought that it's possible to store the transaction in one table row, is to use tokens.. but that would be messy. Anyone got a cleaner way of doing this?
Thank you for reading!