get the value of a field pointed by a foreign key

[Dave_Goodchild]

I think you need to look into Associations, which manage the table relationships in your models.