Getting Started

 View Only
  • 1.  Empty Field

    Posted 15 days ago
    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
    ------------------------------


  • 2.  RE: Empty Field

    Posted 14 days 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
    ------------------------------