Color Picker

[Michelle Logan]

I think I am in the correct section?

What I am trying to do is to create a db for my students to select color combinations, like the color wheel.

I would like to be able to select a color from a Value List in field one (First Color) and a second color from a Value List in field two (Second Color)and have the results displayed in field three.

First Color: Blue

Second Color: Yellow

Result: Green

Do I need a join table for this? My book is not very clear.

M. Logan

[comment]

If it's always two colors, then no - you don't need a join table.

However, without one it will be more difficult to find combinations that contain "Blue" (you'll have to search both fields) and even more difficult to produce a report of the most favorite colors, for example.