Help

  • Thread starter Thread starter T1400
  • Start date Start date
T

T1400

Example

Food Color Meat Seafood
Green
Blue
Yellow
Grass
Steak
Shrimp

Can I reuse fields for multiple use. Like, steak is a
food and meat, using check boxes, shrimp is a food and
meat.
 
Can I reuse fields for multiple use. Like, steak is a
food and meat, using check boxes, shrimp is a food and
meat.
Click to expand...

No. A field in a relational database is "atomic" - it has only one
value.

If you have a many to many relationship (say between food items and
categories), you need to create three Tables - Items, Categories, and
CategoryAssignment say. If an item is in five categories, you'ld add
five records to CategoryAssignment.
 
Back
Top