Add New Record

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

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
 
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
 
Back
Top