Use repeating fields or related tables for inventory database?
Hi, I need to build a new inventory database of products from scratch. Most of the products has different colours which I need to keep track of. Should I duplicate the record and store each new colour as a record on its on?
I did a search and thought of other possibilities like using repeating fields or related tables.
Any advise will be greatly appreciated.