Do you need to store any info about the relationship? Or just the fact that it exists? If you're OK simply knowing that the relationship exists, you can create a m2m relationship from Company to Address, which will manifest in a table with 2 columns - CompanyPK & AddressPK.
On Wed, Oct 28, 2009 at 10:14 AM, Jason Durham <[email protected]> wrote: > I have an Address object. I also have a Company object as well as a User > object. Both Companies and Users can have addresses. Users may have the > same address as their company. Each Company can have several Users. > > In the "old days" of SQL, I would establish a join table between Company > (with a FK) and Address (PK only). And a separate join table for User and > Address. For the sake of simplicity, I'll just ask about the Company > > Address relationship. > > I'm having a hard time wrapping my head around the M2M relationship and how > a join table fits into an ORM. Logically, I'd like to ask the Company for > its address. So, it seems that I'll need to create a method in my > CompanyDecorator to ask the "CompanyAddresses" join object to retrieve its > addresses? Then create new "Addresses" property on the Company object > holding the resulting array of Address objects? > > Or... is it possible (this is when my head turns to mush) for me to create > a o2m relationship on the Company linking to the join table? Then perhaps I > could continue to ask down the chain of objects for the Address? Something > like... > > |----------get class---------------|-----ask o2m-----|------------ask > m2m----------|---ask for Address objects---| > > Transfer.get("my.Class",45).getAddresses().getCompanyAddresses().getAddressArray() > > I realize that the last bit of code isn't going to work... (read above > about "mush"), but it seems there might be a way for me to drill down using > the supplied o2m/m2m methods. Is this true? Or perhaps you can't have an > o2m and m2m using the same FK? I think read that somewhere.... So... I > wouldn't mind having 2 columns with the same data in them (same FKs). > -- > Jason Durham > > > -- > Jason Durham > > > > -- Bob Silverberg www.silverwareconsulting.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" 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/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
