You have to specify the association between division and requseraccount
In your models directory:
class Division < ActiveRecord::Base
class Requseraccount < ActiveRecord::Base
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
Michael R wrote:
I am attempting to display data in the requseraccount form, from the
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.