1 value stored in 2 tables

A

Aamer Sheikh

Is it possible to save one entry in two tables simultaneaously
i.e if i save an item name in items table it also saves the item name in
catagory table
 
J

John Vinson

Is it possible to save one entry in two tables simultaneaously
i.e if i save an item name in items table it also saves the item name in
catagory table
Click to expand...

It's possible. However it's almost NEVER a good idea! The whole point
of relational databases is that you store data ONCE, and don't store
it redundantly. If the name is stored in the items table then it
should NOT be stored in the category table.

If you disagree, could you explain why a Category should have an
itemname? Does each category apply to one and only one item?

John W. Vinson[MVP]
(no longer chatting for now)
 
Top