Results 1 to 3 of 3
  1. #1
    nsteff is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2017
    Location
    Pennsylvania
    Posts
    3

    Post Automatically create 3 records in Table 2 (each with different data) when record created in Table 1?


    I am rusty on Access and need help. I have 2 separate tables - Observation (Observation ID is key) and Risk (Risk ID is key). There are 7 fields in the Risk table, one being Observation ID in order to create a relationship link between the 2 tables. Another is Site, which looks to a 3rd table (Site) that only acts to provide a dropdown list of 3 sites to choose from. What I want to happen is that every time a record is added in the Observation table (new Observation ID) that automatically 3 records are created in the Risk table, each with a different site from the dropdown list in the Site table. The other 4 of 7 fields will remain blank, awaiting individual site personnel to populate.

    Summary:
    New record in Observation Table = 3 new records in Risk Table (record 1 for Site A, record 2 for Site B, record 3 for Site C)

    Your instruction is appreciated... haven't created DB since 2003... very rusty! Thank you.

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Will you be adding data via a form?


    Sent from my iPhone using Tapatalk

  3. #3
    nsteff is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2017
    Location
    Pennsylvania
    Posts
    3
    Yes, the data will be added to a subform.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 07-15-2016, 03:17 PM
  2. Replies: 3
    Last Post: 01-15-2014, 10:39 PM
  3. Replies: 3
    Last Post: 10-02-2012, 12:25 PM
  4. Replies: 7
    Last Post: 04-17-2012, 11:53 AM
  5. Replies: 1
    Last Post: 09-21-2010, 09:49 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums