My Schema.rb is below
ActiveRecord::Schema.define(version: 2019_05_27_040649) do
create_table “days”, force: :cascade do |t|
t.integer “season_id”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
t.date “raceday”
t.index [“season_id”], name: “index_days_on_season_id”
end
create_table “points”, force: :cascade do |t|
t.text “place”
t.text “riders”
t.integer “racepoints”
t.text “status”
t.integer “race_id”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
t.index [“race_id”], name: “index_points_on_race_id”
end
create_table “races”, force: :cascade do |t|
t.boolean “display”
t.text “racename”
t.integer “season_id”
t.integer “day_id”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
t.text “raceclass”
t.index [“day_id”], name: “index_races_on_day_id”
t.index [“season_id”], name: “index_races_on_season_id”
end
create_table “seasons”, force: :cascade do |t|
t.date “year”
t.datetime “created_at”, null: false
t.datetime “updated_at”, null: false
end
end
I want to end up with something like this for the race index.html.erb file
You select the season it then displays the days for the the selected season. You then select the day and the races for that day are displayed.
The four tables are joined and the results is displayed in the Race Details.
My current points index.html is this.
<%= notice %>
Points
<%= collection_select(:season, :id, Season.all, :id, :year, {}, {:multiple => false}) %>
<%= collection_select(:day, :id, Day.all, :id, :raceday, {}, {:multiple => false}) %>
<%= collection_select(:race, :id, Race.all, :id, :racename, {}, {:multiple => false}) %>
I am thinking of using a grouped_collection_select to populate the relevant dropdowns . I know I need to Jquery or javascript to pass the selected options from one drop down to another .but can’t get it to work
Cheers Dave