StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSelecting multiple values via join table using simple form
primarykey
Id
19109250
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-10-01T06:15:35.837
FavoriteCount
0
LastActivityDate
2014-01-04T21:09:48.240
LastEditDate
LastEditorUserId
0
OwnerUserId
2757483
ParentId
0
PostTypeId
1
Score
0
ViewCount
231
LastEditorDisplayName
text
Body
I have a quick question concerning join tables and multiple selections on a form. I have two models in a Rails App (4.0), one is called Skills, and the other, Opportunity. An opportunity can have many skills associated with it, and a skill can be associated with many opportunities. Because of that type of relationship I created a join table called Opportunity_Skills. This table just has skill_id, and opportunity_id. Here are my associations written out: <pre><code>class Skill < ActiveRecord::Base has_many :opportunity_skills has_many :opportunities, through: :opportunity_skills end class Opportunity < ActiveRecord::Base has_many :opportunity_skills has_many :skills, through: :opportunity_skills accepts_nested_attributes_for :opportunity_skills end class OpportunitySkill < ActiveRecord::Base belongs_to :opportunity belongs_to :skill end </code></pre> I have created an opportunity 'new' page in order for users to create new opportunities. I would like users to be able to select multiple skills while creating a new opportunity. In order to make that happen I have made the Opportunity model accepted nested attributes for opportunity skills. I can't figure out what I need on my form (using simple form) to make all of the different options show up as check boxes (the values in the skills table). Any ideas or suggestions would be great. If I left out any information and/or just plain didn't make sense please let me know and I can provide more details. Thank you for the help in advance. Cheers, Graham 
Tags
<ruby-on-rails-4><simple-form><checkboxlist><jointable>
Title
Selecting multiple values via join table using simple form
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USGraham Jackson
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. CODoes this help: http://stackoverflow.com/questions/8352977/rails-forms-for-has-many-through-association-with-additional-attributes ?
 singulars
 PostPostId
 POSelecting multiple values via join table using simple form
 UserUserId
 USFuad Saud

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.