I am working with a HABTM join as follows: Customer <--HABTM--> Product
I want to take this one step further and associate a discount % with each join - ie each Customer -> Product relationship has a specific discount. The goal is so that CustomerA and CustomerB could both have the "Rubber Duckie" product available, but due to differing business arrangements, we might offer CustomerA a 50% wholesale discount but only offer a 25% discount to CustomerB. I already added a discount float field in the customers_products table, and while it doesn't break the relationship in Cake, I am not sure how to access any additional data stored on the join table. I can write out the SQL query by hand to accomplish this, but I would like to keep it within Cake's API as much as possible. Suspect it may have something to do with modifying the finder query in one/both of the models? Or am I out of luck? Thanks in advance for any assistance. -Brad --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
