It sounds like Related Table 2 or Related Table 1 is not set somewhere in those records. I think you likely have it set up that the Table 1 (Key Name); Table 2 (Key,Related Table 1, Date); Table 3 (Related Table 2, and Related Table 1). It seems that Related Table 2 is not set in Table 3. You could pass Related Table 1 from Table to and then Table 3 would have Related Table 2 and Related Table 2 - Related Table 1.
I hope that this helps!
------------------------------
John Crosland
------------------------------