I have a question about the best way to proceed with my next project. Basically I work for a manufacturing firm that would like to create a data source that has all the combinations of the products they produce based on the product attributes. This is basically what I am trying to do:
I can't quite wrap my head around how to script the process. As the database design stands fright now I don't have any relationships set up. I was wondering if there was a way to script the process of creating the records in the "Comprehensive Product" table using the descriptions in the characteristic tables?
Thank you in advance.