You can do that in MS SQL with a trigger.
Think of it as an event that fires when a condition is met. IE when table A gets a new entry, the trigger on the ID field will perform a specified script. (your insert into Table 2) Not sure if its possible in Access tho. These guys seem to think not: http://forums.databasejournal.com/showthread.php?threadid=44091 Shaun McCran T: 07792 783 184 E: [email protected] W: www.mccran.co.uk To: [email protected] From: [email protected] Date: Fri, 3 Apr 2009 15:51:11 +0000 Subject: [flexcoders] Re: database question Here is a thought(i know am grasping at straws but will try).is there a way to set the foreign key field in table B to equal the primary Key field of table A so that when an entry is made it reflects. more like binding the two fields together. _________________________________________________________________ View your Twitter and Flickr updates from one place – Learn more! http://clk.atdmt.com/UKM/go/137984870/direct/01/
