Let's say we have the following models:

Product < ActiveRecord::Base
 has_many :products_suppliers
 has_many :suppliers, :through => :products_supplier

Supplier < ActiveRecord::Base
 has_many :products_suppliers
 has_many :products, :through => :products_supplier

ProductsSupplier < ActiveRecord::Base
 belongs_to :supplier
 belongs_to :product
end


Let' say we have this data in the products_suppliers table:

| supplier_id |  product_id |
|      1          |       2         |
|      1          |       1         |
|      2          |       2         |
|      2          |       1         |


So when I do this:

@suppliers = Product.find(1).suppliers, it will return an array with the
suppliers with id 1 and 2.

Let's say I do this:

@supplier = @suppliers[0] #Which is the supplier with id = 1, the one
fetched from the (supplier_id = 1, product_id = 2) record in the
products_suppliers table. Ok, now I got a single instance of a supplier.
**What I want is to get the product_id it was associated with in the
products_suppliers table.** (product_id = 2), might be missing something
simple, but I can't seem to find a way to do that.

Any help appreciated!

Thanks,

Marcelo.

--~--~---------~--~----~------------~-------~--~----~
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 
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to