search for: reference_items

I posted something about this a week ago wihtout response, but have made some progress since. However, I''m still not getting exactly what I want. OK, three core tables: create_table :reference_items do |t| t.column :title, :string, :limit => 255 t.column :year, :integer, :limit => 4 t.column :type, :string t.column :container_id, :integer t.column :collection_id, :integer t.column :original_id, :inte...

I''m trying to understand how to do the following, but am finding myself stuck. I have three main tables; here are the first two: CREATE TABLE reference_items ( "id" integer primary key, "type" varchar(20), "title" varchar(255), "year" year(4) ); CREATE TABLE "agents" ( "id" integer primary key, "type" varchar(20), "sort_name" varchar(255), "description...