I have built a design that I thought was good on normalization and referential integrity, but my query values are NOT coming out correctly. The attached screenshot of the query is multiplying the SumofOrderTotal by 15 and the SumofPostAmount by 5. The latter table has three records of that OrderID and the former table only has one record.
Can anyone point me in the right direction as to why this is happening?