Don't do it as HABTM. Create a model and controller for the joining table and 
use $belongsTo and $hasMany.

Jeremy Burns
Class Outfit

http://www.classoutfit.com

On 14 Sep 2011, at 23:12, driss wrote:

> I have this data structure :
> Product(Id,name);
> Market(Id,name);
> Product HABTM Market ( I mean that i could have products available in
> many Market or store but the price is not the same for example this
> product X is available in Market1 and in Market2 but in market1 it's
> expensive than in Market2) so I figure out that the Join table is the
> Solution for that situation so I have Added the association HABTM
> between Product and Market which is for record called
> Markets_Products  (table) )
> everything is fine until now I created the tables and everything and I
> can add Markets where the product exist in the add method for Product
> all good
> But I want to add extra field in the association table
> Markets_products for example price field
> so Markets_products(Id,market_id,product_id,price) is like that
> Now my problem is How can I add this field in the add view of  product
> next to every market name in  the select box ??????
> 
> -- 
> Our newest site for the community: CakePHP Video Tutorials 
> http://tv.cakephp.org 
> Check out the new CakePHP Questions site http://ask.cakephp.org and help 
> others with their CakePHP related questions.
> 
> 
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
> http://groups.google.com/group/cake-php

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to