Hi, I am trying to make a relation between a purchase and a currency - that is, each purchase is a certain amount and is paid in a certain currency (dollars or pounds). I am doing this so that I will be able to add other currencies later. What I want to do is for the customer to be able to choose from a drop- down box which currency he will be paying in.
Currently I am using a Purchase hasOne Currency - But for some reason it's when I do a findAll() to Purchases it says SQL Error: 1054: Unknown column 'Currency.purchase_id' in 'field list'. (There is a 'currency_id' field in the purchase table, but there is NOT a purchase_id field on the currency table, because I don't want a currency to be tied down to a certain purchase - hence the error). Now I know I could fix this with a HABTM relation, but I don't want the currency to haveMany Purchases - I don't need the extra overhead and table. Is there any belongsToMany relation? (And after I figure that out how do I map the currency name on the Purchase view to the currency_id field?) Thank you, yitzcv --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
