10 Replies Latest reply: Jan 11, 2017 12:57 PM by Lino Alvarez RSS

    Help Needed with Table Structure

    Matt Maino

      I am creating a document with 3 tables and am struggling with joining them together properly.

       

      The tables are:

       

      Accounts - with account level detail

      Cards - with debit card level detail like card number (one to many relationship with accounts but not all accounts have cards)

      Transactions - transaction level detail (one to one relationship with cards but not all transactions are made with cards and many to one relationship with accounts but not all accounts have transactions)

       

      The Cards table needs to join to the accounts table via Account Number and Date without duplicating accounts

      The Transactions table needs to join to the Accounts table via Account Number and Date without duplicating accounts

      The Transactions table and Cards table need to join together via Date and Card Number but not all transactions are made with a card

       

      Does anyone know what this join would look like?

       

      If I left join cards to accounts it duplicates the accounts with as many cards that are on the account.

       

      Thanks