10 Replies Latest reply on Jan 23, 2015 10:23 AM by PatriciaAngelini

    Where to Link Transactions

    PatriciaAngelini

      Title

      Where to Link Transactions

      Post

      Hello, I am looking for advice on where to place a table in a relationship. My main table is Projects. I have a Transactions table for all debits and credits. It is a child table to the parent table, Projects. Here is my dilemma. Transactions can be tied to Presentations, Print Jobs or stand alone expenses. I am trying to figure out if I need to create a join table for transactions. I have attached a snapshot of the current relationship view. I have made tables that have transactions red so you can see where links need to be made. 

       

             
      • The parent table Projects has a one to many relationship with transactions (one project has many transactions)
      •      
      • AFP is a child to the Projects table. One AFP can have many transactions.
      •      
      • Presentation table is a child to the Projects table. One presentation can have many transactions.

      Thank you in advance for your help.

       

      Screen_Shot_2015-01-08_at_9.29.39_AM.png