What is this called? Terminology needed.

[kennyrogersjr]

I have never had the need for this, and I'll do my best to describe this completely off-the-wall thought.

Let's lay the framework: Database topic - Clothes.

One can have multiple Shirts, pants, shoes, underwear, etc. You guys know what clothes are ;p.
One can have different colors for said clothes.


One can have different quantities, as well.

What do you call it when a clothing item has multiple colors? For example, a Shirt is both black and white or a shoe is both blue and green.

In the design process, I would typically create a table for each color and a table for each type of clothing. I'd let the quantities either sit in the customer table or the specific clothing item's table, depending if this was for one or many persons. I'm missing a table join somewhere, and, not to mention, how the record would look. How can a record field have multiple references contained within that record? It can't, based on what I know. Can someone smarter than me let me know what I really want to ask so I can stop arguing with myself?

Again, I've only been thinking about this-- I ask for the benefit of mankind ;p.

Cheers!

[ranman256]

Term:1 to many tables.
1 clothing item has many colors.

So I see 1 clothing table tItems w fields:
ItemID : 88502
Descr : Shirt

Then 1 Item color table: tItmColor
ItemID
Color

there would be many colors for ITEMID 88502
[ItemID] [Color]
88502 red
88502 black

[kennyrogersjr]

Remember those times when you keep looking at a word and it doesn't look like a word or appears foreign?

I could swear that it was going to look like:
[ItemID] [Color]
88502 red,black

I definitely knew there was a one-many relationship there, just thought that there was a different term other than WRONG for what was in my head. I should learn to listen to my inner voice...

[orange]

I recommend you work through this tutorial to get a better appreciation of tables and relationships.

[kennyrogersjr]

-.- .