AnsweredAssumed Answered

Database creation Theory

Question asked by sackling on Mar 15, 2010
Latest reply on Mar 15, 2010 by sackling


Database creation Theory




I work for a company that makes jewelry. They need to easily be able to order different stones, and gold/silver as well as the labor required per item number.


I am very new to databases so I need some help just figuring out how to create this. Since there are a bunch of different stones to order depending on the product...Should I make a seperate field for each type of stone.. or should there be one filed called stones and each entry within it would be a different stone?


the problem I see is that I have to type the style number in a field. so I would have the style number and it would need to be matched up with 7 different stones for example.


Any assistance is greatly appreciated! Thanks,