Hi,
I have a model tests_user and score which are associated with each other by
has_one and belongs_to association.
class TestsUser < ActiveRecord::Base
has_one :score, :foreign_key => :reg_no
end
class TestsUser < ActiveRecord::Base
end
where reg_no is a unique field in both the table!
You only need reg_no in the scores table
score = Score.find(:first) gives me the first record from score table
Now as i do score.tests_user it gives nill.
and same with if i do
test_user = TestsUser.find(:first)
then test_user.score is showing as nil...
Is this issue because of the foreign_key is not the default id!!!!
There should be no problem with a non-default foreign key. What do
you see if you do
score = Score.find(:first).reg_no
It should be an id of a TestsUser
I have a model tests_user and score which are associated with each other by
has_one and belongs_to association.
class TestsUser < ActiveRecord::Base
has_one :score, :foreign_key => :reg_no
end
class TestsUser < ActiveRecord::Base
belongs_to :tests_user, :foreign_key => :reg_no
end
where reg_no is a unique field in both the table!
In addition to what colin has said, with what you have there rails
will assume there is a reg_no column on the tests_user table which
references the id column on the other table. If it needs to point at a
column other that id then you need to use the primary_key option in
addition to the foreign_key option.