appending a new record in an access table to another table

[jdashm]

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.

[orange]

Why not an Insert query, that gets executed after the successful update/edit of the other table?

Good luck.

[jdashm]

Thanks for the reply. By an Insert Query I assume you mean using SQL. My SQL skills are not great. Could you assist me with the syntax I could use and whether I need to create a query or use this in VBA.
The main goal is to create a record in a table after a new record is added to another table (they are related) IF a yes/no field in that table is True. I only need some of the fields (i.e. Job Number, Product Name, Delivery Date). Thanks in advance for your help.

[orange]

See w3schools for Insert query syntax, examples, and a "try it yourself" area.

Martin Green has great tutorials on SQL and VBA starting here.

[vicsaccess]

try this https://www.youtube.com/watch?v=bOnF...03jQ_t9nFV737s
its a good series, #'s 15,16 & 17 should show you the basics.

[jdashm]

Thanks much. That was a big help. Got it done!!!