Hi,
When we are associating characteristic to a product specification, what is the best practice ? creating a copy of characteristic in the product_specification_characteristic relation (or) instead of copying, just referring to the characteristic via the id ?
When we take first approach, every time there is any change to a given characteristic, there requires updation to all the specifications that uses this characteristic, which otherwise is not a problem when we are just using the reference.
When we take second approach, when ever we need a change to the definition of the characteristic, but don't want this change for a given set of specifications that are using this characteristic, this referencing might be a problem.
Any suggestions please ?
------------------------------
Mahesh Kothamasu
SP Telecommunications Pte Ltd
------------------------------