Forum Discussion

MikeSanders's avatar
MikeSanders
Qrew Member
2 years ago

Empty Field

I don't know how to describe this question, but here goes.  I have 3 tables.  Table 1 is a parent to Table 2 and Table 3.  Table 2 is a parent to Table 3.  I have a report in Table 3 that gets name from Table 1 and Date from Table 2, along with several fields from Table 3.  The Date from Table 2 does not come in, it's all blanks.  Any idea what I'm doing wrong?

------------------------------
Mike S
------------------------------
  • JohnCrosland's avatar
    JohnCrosland
    Qrew Trainee
    2 years ago
    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
    ------------------------------