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 [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to