Append new records only

[Guest]

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....

 

[Joseph Meehan]

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....

Use the no duplicates feature for the number fields you want no
duplicates.

 

[Guest]

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.

 

[Joseph Meehan]

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.

I am not sure I understand exactly what you are saying. However I will
give it a try.

The child table must include a link to the parent table. That is often
based on an auto number in the parent table. If this number is changed in
either table it will loose the link.

The child table may also have other ID numbers including it's own unique
ID which would normally be an auto number. It is this second number not the
linking number in the child table that would be the PK for the child table.
That PX in the parent may be called a secondary key in the child table.