Access 2010 introduced event-driven Data Macros that are similar to triggers. The process described in the question can easily be done with an After Delete data macro on the [Insert_Record] table:
More Related Contents:
- Combine values from related rows into a single concatenated string value
- How do you use version control with Access development?
- Bang Notation and Dot Notation in VBA and MS-Access
- “General error Unable to open registry key Temporary (volatile) …” from Access ODBC
- Is there a simple way of populating dropdown in this Access Database schema?
- How do I make a stored procedure in MS Access?
- How can I get table names from an MS Access Database?
- Is there any way to create multiple insert statements in a ms-access query?
- Running Microsoft Access as a Scheduled Task
- How to diagnose MS access crashes
- “Operation must use an updateable query” error in MS Access
- VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
- Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
- MS Access LIMIT X, Y
- Prevent enabling of shift bypass – Access 2010
- Access 2007 – Left Join to a query returns #Error instead of Null
- Access query producing results like ROW_NUMBER() in T-SQL
- Pivot Query in MS Access
- insert query with sequential primary key
- Is MS Access (JET) suitable for multiuser access?
- Save password for ODBC connection to MS SQL server from MS Access 2007
- How to write Case Sensitive Query for MS Access?
- Setting up an MS-Access DB for multi-user access
- Access VBA: Find max number in column and add 1
- ConcatRelated function in a query
- Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
- Create sequential ID value based on the year that a record is added
- How to use cross join in access?
- Get Name of Current VBA Function
- How to extract the schema of an Access (.mdb) database?