Unanswered: Problems Querying multi table database
I have built a four table database with one parent table connected to three other tables through three one to many relationships. as diagrammed below. I am trying to query all four tables so as to create a report about each entry in the parent table. My problem is that when i run the query i get a Cartesian product and the entrees are multiplied four times. Any help would be awesome.
FROM ((Parent INNER JOIN Approps ON Parent.Agency_Account = Approps.Agency_Account)
INNER JOIN Estimates ON Parent.Agency_Account = Estimates.Agency_Account)
INNER JOIN FootNote ON Parent.Agency_Account = FootNote.Agency_Account;
Anyway, there probably should be a single table for Approps, Estimates and FootNote as the 3 tables have the same structure. One additional column would indicate the type of row (Approps, Estimates or FootNote).