Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update Multi Tables (2000)

    I have a form set for Data Entry that updates the maser table [Locations] by adding a new row and assigning an AutoNumber to that row whice is the Primary Key. I have a second table with a one-to-one relationship on that primary key. The relationship is set with Cascade Update Related Fields.

    While I can add rows to the [locations] table , how do I get the new row to also add a new row to the [LeaseTbl]?
    There is always a way.

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

    Re: Update Multi Tables (2000)

    Is there a specific reason for having two tables with a one-to-one relationship? Unless you really need a humongous number of fields, or your record size is very large, it is much easier to keep all fields in one table. With two separate tables, you always run the danger that their synchronization goes wrong.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update Multi Tables (2000)

    A humongus number of fields is an understatement.

    There are countless fields that I am updating in a few categories and when I reached the limitin one table I added the new.

    Yes - synchronization went very wrong.
    There is always a way.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Update Multi Tables (2000)

    Cascading updates doesn't mean what you think it does. It just means that if a key is changed, the change will be cascaded to the subordinate records, not that a new subordinate record will be created automatically, You won't get the matching ID until you create a record in the second table as well by entering some other data into it. The relationshp defines how records in the two tables connect to one another, so you have to create a record on both sides before it works.
    Charlotte

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Update Multi Tables (2000)

    <hr>when I reached the limitin one table I added the new<hr>
    That sounds like a very bad design, indeed! The purpose of a table is to hold one *kind* data. If you are reaching the "limit" on fields in a table, you need to do some basic study on normalization and redesign this before it gets any worse.
    Charlotte

Posting Permissions

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