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

    Where to Link Transactions



      Where to Link Transactions


      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.