您的位置: 首页  >  技术问答  >  MS Access触发?

MS Access触发?

分类: 技术问答 • 2022-03-15 14:06:27

MS Access触发?

问题描述：

我在MS Access中有两个名为[Insert_Record]和[Delete_Record]的表.这两个表具有相同的字段，但是一个表具有记录，而另一个表则没有记录.

I have two tables named [Insert_Record] and [Delete_Record] in MS Access. Both tables have the same fields but one table has records whereas another table has no record.

问题:我想每当我从[Insert_Record]表中删除任何记录时，整个记录应自动插入到另一个表中，即[Delete Record].

Question: I want, whenever I delete any record from the table [Insert_Record] that entire record should automatically insert into another table, i.e: [Delete Record].

我该怎么做?

答

Access 2010引入了事件驱动的

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:

相关推荐