# N:N association

**URL:** <https://www.ruby-forum.com/t/n-n-association/136622>\
**Category:** Rails\
**Created:** [May 4, 2008, 6:01pm UTC](https://www.ruby-forum.com/t/n-n-association/136622 "2008-05-04T18:01:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![david](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/aeb1de/32.png) [@david](https://www.ruby-forum.com/u/david)\
**Post date:** [May 4, 2008, 6:01pm UTC](https://www.ruby-forum.com/t/n-n-association/136622/1 "2008-05-04T18:01:33Z")

</div>

Hello everybody,

I would like to configure this configuration:

## clients

id  
name  
city

## products

id  
name  
price

## clients\_products

client\_id  
product\_id  
date  
ip\_address

…But I am not sure about this following config because  
clients\_products table had “date” and “ip\_address” attributs. Do you  
think I need to build a model for clients\_products able?

class Client \< ActiveRecord::Base  
has\_and\_belongs\_to°many :products  
end

class Product \< ActiveRecord::Base  
has\_and\_belongs\_to°many :clients  
end

Thanks

---

<div class="post-metadata">

**Author:** ![david](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/aeb1de/32.png) [@david](https://www.ruby-forum.com/u/david)\
**Post date:** [May 4, 2008, 6:09pm UTC](https://www.ruby-forum.com/t/n-n-association/136622/2 "2008-05-04T18:09:28Z")

</div>

Hi,

The habtm relationship doesn´t work when the inner table has other  
data then the id’s.

So you will need a model for it and then you’ll need the has\_many  
:through for having clients at products and vice-versa.

On Sun, May 4, 2008 at 1:01 PM, David B.  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> client\_id  
> class Client \< ActiveRecord::Base  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> >

–  
Rafael Gaspar - removed\_email\_address@domain.invalid  
[http://www.eucomomaca.com](http://www.eucomomaca.com)

---

<div class="post-metadata">

**Author:** ![david](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/aeb1de/32.png) [@david](https://www.ruby-forum.com/u/david)\
**Post date:** [May 5, 2008, 12:21am UTC](https://www.ruby-forum.com/t/n-n-association/136622/3 "2008-05-05T00:21:00Z")

</div>

Hum, okay… Thank you 🙂