Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Pgh
    Posts
    8

    Post Unanswered: Join or Link - Need Help

    Hello I here is my situation.

    I have 3 Tables:

    Table 1 -
    Fields: Table1_ID
    Table1_Name
    Table1_Info

    Table 2 -
    Fields: Table2_ID
    Table2_Name
    Table2_Info

    Table 3 -
    Fields: PrimaryKey
    Table1_ID
    Table2_ID
    OtherInfo

    I need to have a relationship that when I enter a new record in Table1 it adds the number of records in Table 2 into Table 3. I am not for sure if I should use a Join or Link. Hopefully my example will help.

    example:

    Table 1 -
    Fields: Table1_ID, Table1_Name, Table1_Info
    1, Nameof1, 1Info
    2, Nameof2, 2Info

    Table 2 -
    Fields: Table2_ID, Table2_Name, Table2_Info
    1, table2name1, 1table2Info
    2, table2name2, 2table2Info

    Table 3 -
    Fields: PrimaryKey, Table1_ID, Table2_ID, OtherInfo
    1, 1, 1, OtherInfo11
    2, 1, 2, OtherInfo12
    3, 2, 1, OtherInfo21
    4, 2, 2, OtherInfo22

    I think that a join would be helpful in this situation but not really for sure how to implement it. Please Advise.

  2. #2
    Join Date
    Apr 2003
    Posts
    17

    Re: Join or Link - Need Help

    Hi Buddy
    this is lil bit tricky question and u seems to be lazy ;-) sorry just joking
    U can easily do this in VBA in the AFTER INSERT EVENT. I dont think( from my scope) Cascade Update links work here in your example while inserting a new record. Anyway seek better answers. all the best

    Jos

Posting Permissions

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