Hi, I have a small business selling my own embroidery kits. I want to produce a detailed list of the contents of each kit, so when i need to make up more kits, I know exactly what goes into each one.
Each kits has multiple thread colours of differing amounts. I want to include the thread number and the amount of thread for that number, for example, colour 386, 2m, colour 000, 1m and so on. At the moment the kits have limited numbers of threads and so I could just add multiple columns (thread 1, thread 2 etc), but once I get past 5 or so colours this may become onerous and unwieldy. Is there an alternative anyone can suggest?
I’m afraid I don’t think I do. Do you mean create another table listing all the embroidery threads and link the tables? How do I then add the length required? It will be different amounts within the kit and between kits