I am trying to put together an app, just as a learning exercise, that a manufacturing plant could use. The biggest feature that I would like to have is a multi-dimension customized product matrix. I would like the clients to be able to create a single "product" that has various options to the product to create different products. Example: Picture frames. A specific frame has a profile, a shape, a size and a color. I would like the client to create a single "product", the profile, that has various shapes, sizes and colors that could be chosen.
I have thought of accomplishing this by having separate tables created for each of these "products", but that would mean that I do not have a single table with all my product codes in it.
Does anyone have any ideas on how to implement a product matrix that allows the users to specify the different dimensions this way?
Thanx in advance.