Using the primary or foreign key field in a layout?
I'm trying to get my head around key fields a little better, and what FM uses them for. One thing I don't understand is why would you use the foreign key field over the primary key field (of the same relationship) in a layout and vice versa? They both contain the same data right (since the foreign key just takes from the primary key)? So what would be the difference?
Is it correct to say that there is no need for a foreign key other than to establish a relationship?