I am trying to control the colour of the model through the design table, so that the same model can be used but with different colour options.
Yes, Calculating a Color Value in a Design Table
If in doubt, Deepak Gupta probably knows.
Another easy way to get the color parameter into the DT is to make one or more configurations a different color then edit the DT. You will be prompted to add the color and any other parameter that is different to the DT. You can set the color values in the DT or you can just make sure each configuration has something in the column for the color value and then manually change the colors of your configurations. The new color values will update in the DT.
Retrieving data ...