Our company sells products in Thailand.
However , now what they are doing is for a product , they have different prices in different regions and it is based on UOM or the region in which product is sold.
I need to create a combination of 4 fields as the primary key to determine price of a product.
By that I mean, if any of the field of 4 fields has a different value , then the existing combination.
A new price for the product will be stored.
How can I create such a key?