Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Splitting a table (2003 sp2)

    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.
    Thanks
    chuck

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Splitting a table (2003 sp2)

    The screenshot below shows what my suggestion would be.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Splitting a table (2003 sp2)

    Here is a slightly different one.

    Your central table records tax payments. Each payment has an amount and a date, and is to an authority, and is about a parcel (and therefore also about an asset).
    You could make more than one payment to the same authority about the same parcel, so I have given that table an autonumber field as a key.
    Regards
    John



  4. #4
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Splitting a table (2003 sp2)

    I see the error of my ways. I had combined the Parces ID and Tax Authority ID as a single key. Thanks for your help.
    Thanks
    chuck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •