On Dec 5, 7:26 am, Rémi Gagnon <[EMAIL PROTECTED]> wrote: > Thank you. But is there a way to navigate that relationship, not by a > find?
Not sure I understand the question exactly... you can use has_many and belongs_to to help navigate: class Police has_many :transactions has_many :products end class Transaction belongs_to :police belongs_to :product end class product has_many :transactions belongs_to :police end For example: p = Product.find(1) You can do: p.transactions p.transactions.first.police Similarly t = Transaction.last t.products t.products.first.police Or maybe I misunderstood your question? Jeff www.purpleworkshops.com > > I think the design is fine, actually. If I understand correctly, your > > transactions table has columns police_id and product_id (and others). > > > If so, you can find a transaction this way: > > > Transaction.find_by_police_and_product(police, product) > > > This will return the first one that matches. You can also add further > > conditions, ordering, etc. as with any other find. > > > Jeff > > >www.purpleworkshops.com > > -- > Posted viahttp://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
