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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---