AnsweredAssumed Answered

Database creation Theory

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

Title

Database creation Theory

Post

Hello,

 

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,

 

Rob

Outcomes