Append new records only

S

Songoku

Howdy,

how do i go about updating new entry records only?

I have a main table where record number is the PK and several child tables
which store data relating to record number, what i need is to append new
record numbers to the relevant child tables and not duplicate them.

suggestions appreciated....
 
S

Songoku

problem is the main table is record numebr is an auto number and when I
append this it is copying current numbers where all i want is for just the
new autonumber to be copied to the child tables. in the child tables record
number is the PK for that table.
 
Top