Displaying 1 result from an estimated 1 matches for "colorid".
Did you mean:
colored
2007 Jan 08
3
Relating Tables
...display the ColorName to web visitors when they view
Products.
I can do a number of things:
1) put Color.ID into Product.Color1, Product.Color2 and Product.Color3.
These would be Foreign Keys and from what I read, RoR likes that.
2) Create a new table called ProductColors which would have an ID,
ColorID, and ProductID columns as used in many-to-many relations.
3) Use ColorName varchar in the Products table for Color1, Color2, and
Color3.
My actual database has a number of tables similar to Color, where all I
really need to do is link a varchar field to the Products table.
- Which solution would...