AnsweredAssumed Answered

Where to Link Transactions

Question asked by PatriciaAngelini on Jan 8, 2015
Latest reply on Jan 23, 2015 by 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

Outcomes