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.