View Single Post
  #3 (permalink)  
Old 07-10-2007, 08:13 AM
ccoonen ccoonen is offline
PT Staff
Awards Showcase
Quality Tutorial Quality Tutorial Quality Tutorial Quality Tutorial 
Total Awards: 4
Join Date: Jun 2007
Location: Wisconsin
Posts: 317
iTrader: (0)
ccoonen is on a distinguished roadccoonen is on a distinguished roadccoonen is on a distinguished roadccoonen is on a distinguished road
Seems like you need a mapping table... if this is what your asking?

Table 1: Clothes
Table 2: Color
Table 3: Clothes_Color (Mapping Table)

This way you can have a many - to - many relationship and have infinite combinations of anything
Reply With Quote