Virtual fields or other solution

Hi there,

need a little help, 

I have a simple model where the data is stored in the following format: 

id | product_id | period | price ..
------------------------------------
1  | 1          | 10     | 9.99
2  | 1          | 20     | 18.99
3  | 1          | 30     | 27.99

Each product will have more 'period' data stored in a relational table. 

When we browse all the products I should show these periods as virtual fields. 

eg 

id | name          | period 10 | 20 Period | Period 30
-------------------------------------------------- --------
1  | sweet product | 9.99      | 18.99     | 27.99

Can someone give me directions? 

thank you

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.