AnsweredAssumed Answered

Create new records in a table based on data from multiple tables

Question asked by meyerge on Oct 29, 2018
Latest reply on Oct 30, 2018 by meyerge

Hey Everyone,

 

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:Screen Shot 2018-10-29 at 12.15.41.png

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.

Outcomes