Hi Michael
You have to specify the association between division and requseraccount
models
In your models directory:
division.rb
class Division < ActiveRecord::Base
has_many :requseraccount
end
class Requseraccount < ActiveRecord::Base
belongs_to :division
end
And now you can do the following in your controller and view:
@req = Requseraccount.find(:all, :include => :division)
@req.division.name # "division_name"
You can read more about it at http://guides.rubyonrails.org/. And about
associations in http://guides.rubyonrails.org/association_basics.html
Regards
Michael R wrote:> Hello,
>
> I am attempting to display data in the requseraccount form, from the
> divisions table.
>
> For example: I have a division_id field in requseraccount that works
> great. No issues getting this populated from my create form. The
> problem is that I don''t want to display the id when showing the
form.
> I want to display the division_name, which is in the division table.
>
> Here is a copy of my code
> requseraccounts_controller.rb and schema.rb: http://dpaste.com/35716/
> requseraccoutns: show.html.erb: http://dpaste.com/35717/
> SQL Query: http://dpaste.com/35725/
>
> I get the following error when I try the above code:
>
> ActiveRecord::RecordNotFound in RequseraccountsController#show
>
> Couldn''t find Division with ID=8
>
> Which makes sense, since it is trying to do a query WHERE
> division_id=8. I need the query to use requseaccount.divisions_id
> (which is 2) and not requseraccount.id (which is 8).
>
> Any advice would be much appreciated.
>
> Michael
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---