Hello,
I have a database that tracks projects and quarterly reports for those projects. Each report I create has a set number of transactions associated to it. I have attached a picture of the current relationships and just wanted to get some feedback on whether I have done it correctly.
I am specifically curious about tblProjectTransactionBridge, as I used a structure that came from an invoicing system, so I am not really sure what this table is doing, but so far it seems to work.
Hopefully the image is straight forward enough to give you an idea of what I'm trying to accomplish.
Thanks for the feedback.
I have a database that tracks projects and quarterly reports for those projects. Each report I create has a set number of transactions associated to it. I have attached a picture of the current relationships and just wanted to get some feedback on whether I have done it correctly.
I am specifically curious about tblProjectTransactionBridge, as I used a structure that came from an invoicing system, so I am not really sure what this table is doing, but so far it seems to work.
Hopefully the image is straight forward enough to give you an idea of what I'm trying to accomplish.
Thanks for the feedback.