I think that it is better to have a record for each product/price.
So you'll have ( based on your example ) 5 record, each one with a distinct price and a distinct ID:
ID Product Type Price
1 A unit 10
2 B day 300
3 C hour 40
4 C day 400
Now, if you choose product C, you'll see 2 types.( if there is a correct relationship )
Thank you for your response.
This is the way I have it right now.
I wanted to know if there is an elegant way and having less records.
Less records isn't necessarily better :smileywink:
If you and Daniele's current table design (one record for each value) creates issues for you. Feel free to post a description of that issue. Perhaps one of us can suggest a solution.