I need to build a new database to manage tax payments on real estate properties. I have attached a table to represent the data the database will manage. The table has many to many relationships which I want to break down. I started with my own ideas but get too many records when I join them in a query. I tried the wizard, which broke it down a little differently but when I selected create a query it failed.
The Asset Number represents the property. The Tax Authority breaks the properties into Parcels. An Asset Number may have many Parcels but a Parcel only one Asset Number. An Asset Number may have many Tax Authorities, and a Tax Authority many Asset Numbers. At this point I believe I have a good breakdown of the table, but without including the Amount and Due Date a query doesn’t give me all the records since many Asset Numbers are charged quarterly. I have tried several ways to join the Amount and Due Dates into a query but always get too many records. The Amount is related to the Parcel and the Due Date to the Asset in the real world, but threating them so in a table does not give me the correct results. After a frustrating week I am really looking for some suggestions with this. Any help would be greatly appreciated.
