I am constructing a pivot table with many columns (300) and I wonder if I this is a bad practice.
Here are some details why I need to contruct this table.
A (very) simplified presentation of my database :
I have a company with diverse glass products, windows for example. Each product is referenced by and
ID and has (many)
ID | Attributes | Value 1 | width | 10 1 | height | 15 1 | refraction | 1 1 | thickness | 0.5 1 | rating | 10 ...
Now, I would like to add some (computed) attibutes
For example a new attribute
surface should be defined by
surface=width*height. To do this, I create a pivot table from the
Products, from which I create the computed attributes such as
width*height AS surface.
With this method, I can make a query depending on the
Is this a bad practice to do so, since the number of columns can be very high (300) in my case ? If there is another way to do this kind of operation, you can let me know.
By the way, this exceeds the maximal number of columns of Access...