Add New Record

[Kirstie Adam]

How do i :

Tell my database that when a record is added to Table A, add a record to
Table B with the field [Name] from table A to be copied into the same field
in table B?

TIA,

Kirstie

 

[Arvin Meyer [MVP]]

In a server based database such as SQL-Server that would be handled by a
Trigger. File based databases, such as Access, do not use Triggers. To
simulate a Trigger, use the After Update event of the form to use a
recordset to write the record to the second table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access