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.