Foreign keys from distantly related tables

[torifile]

I'm not sure if I'm describing that right but let me post a screen cap of my database:

So I've got my "main" table related to my "axis 1" table via a relationship through "axes". In my testing, the patientID_fk in "axis 1" does not get created in my "axis 1" table upon a record creation.

edit: I just added another relationship between patientID_fk in the "axes" table and the "axis 1" table and that seemed to do it. Is that right? I also don't know why my screencap is so small. The actual image, full size is here

Edited April 17, 2009 by Guest

[RalphL]

Why do you think you need PatientID in the "Axes 1" table?

[torifile]

Hmm. I don't know. My thinking was that patient IDs should be associated with the Axis tables (there are 5 of them). I suppose they are through the Axes table.