Results 1 to 5 of 5

Thread: Tables Design

  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: Tables Design

    I have 5 tables which are linked with a common ID. When I add an ID to Table 1, I want all the other tables to be automatically updated with that ID.

    Could someone help me with this?

    Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by shiri
    I have 5 tables which are linked with a common ID. When I add an ID to Table 1, I want all the other tables to be automatically updated with that ID.

    Could someone help me with this?

    Thanks.

    in your relationships, check the join property "Cascade Updates" ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    May 2004
    Posts
    3
    I did but it does not seem to work. I have added an ID to Table 1 and have found that the other tables have not been updated.

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by M Owen
    in your relationships, check the join property "Cascade Updates" ...
    My BAD ...

    You'll have to write each record to each table ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by shiri
    I did but it does not seem to work. I have added an ID to Table 1 and have found that the other tables have not been updated.
    If you Zip and Attach your database you might get even better help. Easier when you can see what the person is working with and can usually see things like how it is structured without asking 10,000 questions and waiting for replys between each. Just trying to help.

    have a nice one,
    Bud

Posting Permissions

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