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@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---