Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2001
    Location
    Australia, QLD
    Posts
    5

    Question Unanswered: how can i update linked tables ???

    hi! there access expert!!
    i'm struggling with update tables ..
    in detail i've got more than 800 tables. each table has 21 common fileds
    and have different property fileds..(it's industry materials database)
    i made up the integrated table with each common fileds.
    i also made up the form to search & update integrated table.
    then now i've trouble to update the individual table from the integrated table (called master table & this database has one to one relation ship)

    i mean that when i update master table using the form ...
    i also want to update related individual table..
    how come????

    thanks to you in advance and wish you happy new year!!
    regard paul
    Last edited by paul035; 12-27-01 at 19:15.

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    a couple of questions to clarify your problem..

    Are you trying to populate a table with data from a lookup table using a form?
    -or-
    Are you trying to link a main form to a subform with a 1to1 relationship?
    -or-
    Are you trying to create a matching record (same ID) in a child relation when you add data in the sub-form?

  3. #3
    Join Date
    Nov 2001
    Location
    Australia, QLD
    Posts
    5
    G'day torgue!
    firt of all thanks for your help
    i'm trying to create a matching record (same ID) in a child relation when you add data in the sub-form...

  4. #4
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    If you have a master table with an autonumber primary key (ID)

    Create a child table with a long integer foreign key

    Create a form based on the master table, then add a subform based on the child table. When you use a wizard, the application will prompt you for the fields to link. You can also manually establish or change this link in the properties of the subform.

    Now if you want the child records to be deleted when you delete the matching master records (to avoid ending up with orphan records), you can set up a delete cascading relationship in the relationship feature of your application (under the tools menu). add your two tables, connect the two linked fields, right-click the link and establish the cascading relationship. Note that this can only be done when records are currently matching (or tables are empty). See your help file on more detailed info.
    This feature will also delete child records when you delete master records from the table, without using the form.

    Hope this helps.....

Posting Permissions

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