Ok, really amateur question coming up:
Three relations (A, B, C)
I place a foreign key from relation A into relation B. I then place the same key from relation B into relation C.
Is the placement from relation B into relation C creating a relationship between B and C, or A and C?
Perhaps I am missing some very basic theory here?
Thanks for your help in advance.