>
> TABLE ITEMS (table of all the items to be displayed/sold)
>
> itemID (PK)
>
> TABLE COLORS (table of all the potential colors - used to populate
> itemColors)
>
> colorsID (PK)
> color
>
> TABLE ITEMCOLORS (table listing all colors for a particular item)
>
> itemColorsID (PK)
> itemID
> colorsID
Good.
> What about a field in ITEMS called itemColors so
> that the record for Sweater A would look like
>
> itemID | 1001
> itemName | Sweater A
> itemColor | red, white
Bad.
Jochem
--
Who needs virtual reality
if you can just dream?
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
