I have a project in which I need to create a new record in a table after a record is added in another table. I wanted to use Data Macros to do this but the end user version is Access 2007.
What is the best way to do this. The new record should be triggered after insert when a particular field is true.