Best way to display a sub sub menu

I have a product database working fine.

Products are assigned a main category and a sub category.

What I need to add are product options so the 'rosary beads' sub category will have colour, black, white etc...

I'm wondering what is the best way to do this? A separate 'options' table with the id from the product table?

So the table would be something like...

id   option
13  red
13  black
13  white
14  large
14  medium
14  small
Who is Participating?
johanntagleConnect With a Mentor Commented:
Yes, that would be the most straightforward way to do it.
BrighteyesDesignAuthor Commented:
Cheers John, I'll crack on with that then, just wanted to make sure!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.