View Single Post
  #2 (permalink)  
Old February 4th, 2008, 05:39 PM
BrianWren BrianWren is offline
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

What do you mean you want to "save the data in table 2?"
You want to insert data into table 2?
If that is the case, you can, with a recordset, use the .Add method, then set each field to the value for the new record, setting the field that erlates back to table 1 to the value for NIC of the record you want to relate to.