what else to do to establish many-to-many associations in Ruby on Rails? thanks!

Question

Hi, I have two classes and I want to establish a many-to-many assications, here is the code:

class Category < ActiveRecord::Base
  has_and_belongs_to_many :events
  has_and_belongs_to_many :tips
end

class Tip < ActiveRecord::Base
    has_and_belongs_to_many :categories

However, I kept getting the following errors and I would appreciate it if some one could educate me what is going wrong:

PGError: ERROR:  relation "categories_tips" does not exist
: SELECT "categories".id FROM "categories"  INNER JOIN "categories_tips" ON "categories".id = "categories_tips".category_id WHERE ("categories_tips".tip_id = NULL ) 

the viewer part:
4: <%= text_field :tip, :title %></label></p>
5: 
6: <p><label>Categories<br/>
7: <%= select_tag('categories[]', options_for_select(Category.find(:all).collect {|c| [c.name, c.id] }, @tip.category_ids), :multiple => true ) %></label></p>
8: 
9: <p><label>Location<br/>
10: <%= text_field_with_auto_complete :tip, :abstract %></label></p>

Answer 1

From the documentation:

For the second way, use has_and_belongs_to_many in both models. This requires a join table that has no corresponding model or primary key.

You're missing this table.

Answer 2

Here is a good tutorial from railscasts.