From: portal33@...
Date: 2006-02-03T10:38:20+09:00
Subject: Basic Rails Database Foreign Key question

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:
   id
   description
   submitter_id (foreign key to People id)
   assigned_to_id (foreign key to People id)
   etc

People table with columns:
   id
   name

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

class Person < ActiveRecord::Base
	has_many :problems

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

views:problems:list.rhtml
    <td><%= problem.submitter.name %></td> ???