Forum: Ruby Basic Rails Database Foreign Key question

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
unknown (Guest)
on 2006-02-03 03:41
(Received via mailing list)
Hi, I'm still waiting on my Agile Rails book to arrive - in the
meantime ...
As an exercise I'm making a Help Desk application.
If I have a Problems table with two foreign keys to a People table, how
do I set up my models, problems_controller list method, and then simply
display, say my problem submitter person? Here is what I have so far:

Problems table with columns:
   submitter_id (foreign key to People id)
   assigned_to_id (foreign key to People id)

People table with columns:

class Problem < ActiveRecord::Base
	has_many :people  ???

class Person < ActiveRecord::Base
	has_many :problems

def list
    @submitter = Person.find(params[:submitter_id]  ???

    <td><%= %></td> ???
James B. (Guest)
on 2006-02-03 04:05
(Received via mailing list)
removed_email_address@domain.invalid wrote:
> Hi, I'm still waiting on my Agile Rails book to arrive - in the
> meantime ...

You'll likely get better information from the Rails mailing list
Timothy G. (Guest)
on 2006-02-03 08:39
(Received via mailing list)
In the future, the rails mailing list would be a better place to post
this. This time, here's a solution:

# problem.rb

class Problem < ActiveRecord::Base
  belongs_to :submitter, :class_name => 'Person', :foreign_key =>
  belongs_to :assigned_to, :class_name => 'Person', :foreign_key =>

# end

look at
for full details. You can find the answer to almost every question in
the excellent API documentation available at
This topic is locked and can not be replied to.