Add additional field in a hasandbelongstomany association

Hello--
I am building a site where there will be customers and products. I
built a customers_products table and set up all the
hasandbelongstomany associations correctly.

My table is:

* id
* customer_id
* product_id

Very simple, and it works fine. I want to have the notion of a large
or small version of the product however. It's a food box for a local
organic farm--so you can choose a fruit box, or a food box, etc. The
items you can choose from are the same, you just happen to either get
X or Y quantity depending on the size of the box you order. I want
the person from the farm to only have to set what is available that
week for a generic fruit/food/flower/etc box, and not separate items
for a large vs. small box.

Would I add this "box size" field in the customers_products table, or
somewhere else? Such as:

table customers_products
* id
* customer_id
* product_id
* size

Thanks in advance for any help. I tried to find this answer but I
wasn't coming up with the right terms to search for I guess.

Jason

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---