3 Replies Latest reply on Sep 8, 2014 5:01 PM by philmodjunk

    having trouble figuring out why a table is unrelated

    AdamReed

      Title

      having trouble figuring out why a table is unrelated

      Post

      I'm having difficult displaying an address of one party to a contract.  I have the following tables:

      'address'

      'address / person link'

      'person'

      'person author' (a second instance of the person table, I also have other instances for editor, agent, etc.)

      'person author / book link'

      'book'

      'book / contract link'

      'contract'

       

       

      Everything seems fine from person to contract -- it's fields from the address table I can't get to appear in the contract table.

      If anyone has a sense of what's missing here, that would be very helpful.  I can post an image, too, if that would be useful.

      Thanks,

      Adam